Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have 8 SQL Server installations (on 8 separate servers).

I want a way in which I can estimate future disk space requirements. Can anyone list down the parameters which can be helpful in making such reports?

share|improve this question

2 Answers 2

There is no generic answer to that. Simply said - it depends on the databases. what is also part is not SIZE but more often IO load - IOPS. Especially with large cheap discs you are going to run into an IO limit faster than you can say "damn".

share|improve this answer

You can see the data for each table with sp_spaceused. Build a script that goes over your databases (sp_msforeachtable will help you here) and collate the statistics.

Take data at weekly or monthly intervals, and plot a trend line (you can even do this with Excel). This will give you a rough forecast that you can use to estimate your future disk requirements. Keep an eye on it and re-evaluate your estimates if your forecast value changes significantly.

Note that linear regression (the most likely method used to calculate the trends) assumes a more or less linear growth. If you have reason to think that your disk usage will grow exponentially you may want to use a more clever forecasting technique.

Depending on how loaded your servers are, you may also need to keep an eye on load statistics like Page I/O latch wait times.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.