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
Related Q&A from Hilary Cotter
Learn the new components of Windows XP SP3 including black hole router detection and network access protection. Compare XP SP3 features to Vista and ... Continue Reading
Learn why Oracle VM would be chosen over Hyper-V or VMware and read an expert's recommendations for implementing Oracle VM. Continue Reading
SOA depicts how two services or programs can communicate with each other. Learn why SOA should catch the attention of service providers and the ... Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.