How do I figure out how much database is expected to grow?
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?
Embalsamador
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?
Embalsamador
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 :-).
SQL SERVER EXPERT
more:
Building a simple forecast solution on SQL Server by Terry Choo
http://terrychoo.com/forecast/
Forecasting growth
http://searchsqlserver.techtarget.com/feature/Forecasting-growth
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..)
Thanks,
Ben
fyi- what I'm concerned re the DB see https://www.experts-exchange.com/questions/29013683/Database-maintenance.html?anchor=a42079051¬ificationFollowed=186938705#a42079051
Re the logic, I see its not something simple I can figure out just by doing some plus & minuses, so I guess will stick with what excel is giving w/o looking into the details..
on what schedule?We have a daily backup scheduled.
or is that only the oldest size known?Yes, this is the case.
Thanks,
Ben
Gain unlimited access to on-demand training courses with an Experts Exchange subscription.
Get AccessWhy Experts Exchange?
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
When asked, what has been your best career decision?
Deciding to stick with EE.
Being involved with EE helped me to grow personally and professionally.
Did You Know?
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE
Ask ANY Question
Connect with Certified Experts to gain insight and support on specific technology challenges including:
- Troubleshooting
- Research
- Professional Opinions