
	Home > Ask the Systems Channel Experts > Database Administration Services Questions & Answers > SQL Server capacity planning

Ask The Systems Channel Expert: Questions & Answers

SQL Server capacity planning

Retired Expert - Hilary Cotter

EXPERT RESPONSE FROM: Retired Expert - Hilary Cotter

		Pose a Question

		Other Systems Channel Categories

		Meet all Systems Channel Experts
		Become an Expert for this site

Digg This!

StumbleUpon Toolbar

StumbleUpon

Del.icio.us

>

QUESTION POSED ON: 30 May 2007
Can you offer best practices for database capacity planning?

Digg This!

StumbleUpon Toolbar

StumbleUpon

Del.icio.us

RELATED CONTENT

	Database Administration Services
	What opportunities are there for VARs in a SQL Server upgrade?
	How to decide which disaster recovery strategy is right for customers?
	Why outsource database management services to a VAR?
	Offer SQL Server security services
	Integrating Microsoft Office with SQL Server
	What should I expect when migrating custom applications from SQL Server to MySQL?
	SQL Server database security
	SQL Server 2005 business suite and Microsoft Office integration
	Controlling Microsoft SQL Server sprawl
	Database clustering secures data

Database Performance Tuning and Monitoring Tools

Channel Explained: Federated databases

Oracle Partner Program Checklist

BMC Software Partner Program Checklist

Maintaining performance after a database consolidation

Refining plans for database consolidation

Cleaning up with database consolidation services

How to diagnose and troubleshoot database performance problems

RDBMS performance monitoring tools

Remote DBA services: Overcoming sales hurdles

Oracle DBA trends: Beyond basics

Data Mining, Analytics and Business Intelligence Consulting

Business intelligence software immune to recession

How to work with business intelligence vendors

Introduction to business intelligence tools and reporting

Bridging the IT/business gap in business intelligence projects

Business intelligence consulting: Problems and solutions

SSIS brings business intelligence services prospects

Systems products to pay attention to

Stay competitive with Software as a Service business intelligence services

RDBMS performance monitoring tools

Integrating business intelligence software with Microsoft Excel

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

Database administrators (DBA) use capacity planning to predict the resources that a SQL Server will need over its lifetime, to provide optimal services for the applications using it.

Best practices include:

Ensuring the hardware is modular to permit hardware upgrades.
Ensuring that the server/hardware can be repurposed should the applications outgrow the existing hardware.
Ensuring that a representative load test is done on the hardware to study its performance characteristics.
Ensuring that the hardware selected will be powerful enough to support and take advantages of new features and requirements of SQL Server and application upgrades.

Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.

Browse our Expert Advice
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

About Us | Contact Us | For Advertisers | For Business Partners | Site Index | RSS

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 2006 - 2009, TechTarget \| Read our Privacy Policy