Question Locked

Capacity Plan SQL Server

0 helpful
2 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hello,

I'm working on a capacity plan document for SQL Server databases. I'm not sure of where to start it. I'm doing this for the first time and the problem I'm facing is with the lack of data. I've got the servers in my hand only since last 2 months and still confused where to start it. I need to provide the client with the capacity plan document for the next 6 months in terms of database growth.

I need some sample capacity plan document or any template for database. Please help me in this.
Thanks in advance.

2 replies

by manu0417

After very tough time to start with, I have started by running jobs from a central server by connecting to all the other servers requiring capacity planning (only related to database sizing and disk requirements). The jobs connect to the servers daily and collect the size information of the database and the time it is logged. Every month I run scripts to get the change in the size and how the trends are. After a good observation of trends for next 3 months I was able to predict the capacity requirement for next 6 months.

But again it all depends on how the client business grows and you should always be aware of the huge data chunks that are going to hit the server sooner or later. Hope this helps

This discussion is closed to new replies.