How do I figure out how much database is expected to grow?
Hi Experts,
I have a database that did grow monthly the following in MB
Size
3330
3383
3426
3468
3523
3602
3686
3759
What is the way to calculate the expected growth for the next few months?
You might want to consider whether there are going to be any changes in working practices. New employees hired, big sakes promotion, new direction of work, or a new feed of data now someone has decided that text stores well and perhaps they could store pictures.
Make an estimate by looking at the monthly growth and then double it to add a safety margin. Storage is becoming cheaper all the time so aim for the highest you can afford if you decide to increase it.
Are the numbers you provided the size of the database each month or the increase in size from the previous month?
Enabbar Ocap
Saw the typoo and tried to change it but the edit function was broken.
Scott Pletcher
At a base level, that's primarily a math q, and many math folks could give you very detailed answers on trending, stat analysis, etc..
In a db context, that's too small to spend that much time worrying about. I think this is related to your SQL Express q, and I think I might've taken care of that now too :-).
So far I tested bisqueezers suggestion and seems to work, would someone know whats the calculation behind it?
(the links provided are way to complicated for me to follow..)
Is there any database maintenance being done? What purging happens, on what schedule? Are reorgs done? (Does any maintenance reflect in the given figures?) Was the initial size "3330" MB, or is that only the oldest size known?