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

## 2 replies

Last post Feb 27, 2015 12:32 AM by Edwin Guru Singh

• slimbunny

Participant

809 Points

1409 Posts

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

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

• PatriceSc

All-Star

41010 Points

13522 Posts

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

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?

• Edwin Guru S...

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

`Select 200+500`

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

`select 700*.35 `

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

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

`Select(5000-700)/245`

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

--
with regards,
Edwin

with regards,
Edwin