Chapter 9. Capacity planning
Greg Larsen
As a DBA, you have lots of different tasks to take on to manage and maintain your SQL Server environment. You need to install and configure SQL Server, make database schema changes, and perform a slew of other tasks like implementing backups and managing user access security. The list goes on and on. One of the tasks that is occasionally overlooked is capacity planning.
Capacity planning isn’t just one task but a number of different tasks. Some people think capacity planning is just disk space management. It’s partly that, but it’s also more than that. In this chapter I’ll discuss managing the space and performance capacity of your SQL Server environment.
There’s no single formula for capacity planning. ...
Get SQL Server MVP Deep Dives, Volume 2 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
