I often get asked a question similar to that; I need to figure out how to calculate what my database size will be 12 months down the road, or 24 months, or 36 months? But how do I do that?
There is a simple formula we can use to calculate this; however in order to do it we need to know few key values.
- What is current size? (CurrentSize(mb))
- What is the expected monthly growth in percent? (ProjectedGrowthPerMonth(%))
- How many months we want to know growth for? (NumberOfMonthsToProject)
So lets take this formula and try to calculate the growth for a database. Lets say we have a database that is 10240MB and it is projected to grow by 10% per month. What would be its size in 12 months from now?
NewSize (MB) = 10240MB * [(1 + 10%) ^ 12] = 10240MB * [1.10 ^ 12] = 10240MB * 3.14 = 32153MB approx.
We can verify our final value by doing manual calculation like so …
|Month||Size @ Start||Growth||Final Size|
We can see the final size is approx same as one calculated above. Most likely difference occured because I rounded off the “3.14”; where as table above is generated via Microsoft Excel handling the rounding for me.