I have a database scenario where my database is 200 and 500 GB of data with a

total volume of data on disk is currently 5TB.

The data is growing at a rate of 35% per year; how do I calculate the estimated size of the database 1 year from now and what would it be two years from now?

1,35 * currentsize (and *1.35 again the next year)? It seems to be just math and I'm not sure what is the "SQL Data size math" you are talking about (it is rather use when you want to estimate the size a table will take depending on columns types?)

Also I don't really get what are the 3 numbers you gave. Could it be the actual data size taken in two db files and the current total file size is 5TB bytes to allow for growth?

Participant

809 Points

1409 Posts

## How to calculate data space for a database with growing rate of 35%..?

Feb 25, 2015 09:11 PM|slimbunny|LINK

How do I calculate data space?

I have a database scenario where my database is 200 and 500 GB of data with a

total volume of data on disk is currently 5TB.

The data is growing at a rate of 35% per year; how do I calculate the estimated size of the database 1 year from now and what would it be two years from now?

Need SQL Data size math help...please

All-Star

41010 Points

13522 Posts

## Re: How to calculate data space for a database with growing rate of 35%..?

Feb 26, 2015 07:23 AM|PatriceSc|LINK

Hi,

1,35 * currentsize (and *1.35 again the next year)? It seems to be just math and I'm not sure what is the "SQL Data size math" you are talking about (it is rather use when you want to estimate the size a table will take depending on columns types?)

Also I don't really get what are the 3 numbers you gave. Could it be the actual data size taken in two db files and the current total file size is 5TB bytes to allow for growth?

Star

8524 Points

1376 Posts

## Re: How to calculate data space for a database with growing rate of 35%..?

Feb 27, 2015 12:32 AM|Edwin Guru Singh|LINK

Hi Slimbunny,

As per my understanding of your case, I have been made some calculation below :

1.Basically 1TB=1000 GB

2.So 5TB=5000 GB

3.Your two database having occupying date 200GB+500GB=700GB

4.The data is growing at a rate of 35% per year .35% of 700GB is

245GBSo the estimated size of increasing database for one year is 245GB

5.So formula = (Total Memoryspace-existing space)/35% per year

6. Output is 17 .So calculated total estimated year of your total disk memory is

17 years--

with regards,

Edwin

Edwin