Problem solve
Get help with specific problems with your technologies, process and projects.
SQL Server capacity planning
In order for SQL Server capacity planning to be affective, resellers must plan the hardware to last the life of the server.
Can you offer best practices for database capacity planning?
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.
Dig Deeper on Database software management
-
VMware bids farewell to vCenter Server for Windows
By: Brian Kirsch
-
Why is virtual server capacity planning so difficult?
By: Stephen Bigelow
-
Choosing the right server monitoring tool for your environment
By: Bernard Golden
-
SQL Server upgrade paths: What to do before, during, after upgrading
By: Basit Farooq
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.
Meet all of our IT Channel experts
View all IT Channel questions and answers
Start the conversation
0 comments