SQL Server MVP Deep Dives, Volume 2
by Brad McGehee, Louis Davidson, Greg Low, Kimberly Tripp, Paul S. Randal, Kalen Delaney, Paul Nielsen
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. ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access