Capacity Plan SQL Server

By manu0417 ·

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.

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

Sorry for the late reply but got it done

by manu0417 In reply to Capacity Plan SQL Server

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

Related Discussions

Related Forums