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
Discover the best basic SMB database -- and learn when it's time for your SMB clients to upgrade. Continue Reading
SQL Server database security is as important to a customer as ensuring their servers don't encounter any downtime. These tools will help keep your ... Continue Reading
Rather than throwing hardware to configure a database to support web-based applications with large dynamic datasets, VARs can use architectural ... Continue Reading