We help IT Professionals succeed at work.

How do I figure out how much database is expected to grow?

415 Views
Last Modified: 2017-04-05
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?
Comment
Watch Question

DatabaseMX (Joe Anderson - Microsoft Access MVP)Database Architect / Application Developer
CERTIFIED EXPERT
Top Expert 2007

Commented:
Is this an Access mdb or accdb ?
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Enabbar OcapEmbalsamador
CERTIFIED EXPERT

Commented:
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.
Enabbar OcapEmbalsamador
CERTIFIED EXPERT

Commented:
" big Sales promotion
CERTIFIED EXPERT

Commented:
"big Sales promotion": what if they sell sake?

Are the numbers you provided the size of the database each month or the increase in size from the previous month?
Enabbar OcapEmbalsamador
CERTIFIED EXPERT

Commented:
Saw the typoo and tried to change it but the edit function was broken.
Scott PletcherSenior DBA
CERTIFIED EXPERT
Most Valuable Expert 2018
Distinguished Expert 2019

Commented:
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 :-).
EugeneZSQL SERVER EXPERT
CERTIFIED EXPERT

Commented:
you can try  Bitsqueezer suggestion : "Excel" chart to review and analyze based on your processes, and business specifics

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
CERTIFIED EXPERT

Author

Commented:
Hi Experts,

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
Enabbar OcapEmbalsamador
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
EugeneZSQL SERVER EXPERT
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
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?
CERTIFIED EXPERT

Author

Commented:
Hi Experts,
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
CERTIFIED EXPERT

Author

Commented:
Thank you very much my experts!

Gain unlimited access to on-demand training courses with an Experts Exchange subscription.

Get Access
Why 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.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Empower Your Career
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