Chapter 9. Capacity planning
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. The goal of this chapter is to help you capture capacity planning information and to help you understand why capturing this information is important. It’s up to you to decide what capacity planning information is appropriate for your environment and determine how to use that information to better manage your environment. Ultimately, you’ll define the rules to adopt for your environment and then modify them over time.