Last post Feb 27, 2015 12:32 AM by Edwin Guru Singh
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
Feb 26, 2015 07:23 AM|PatriceSc|LINK
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?
Feb 27, 2015 12:32 AM|Edwin Guru Singh|LINK
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 245GB
So 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