O'Reilly logo

SQL Server MVP Deep Dives Vol. 2 by Kimberly Tripp, Paul Randal, Paul Nielsen, Brad McGehee, Greg Low, Louis Davidson, Kalen Delaney

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required