Avatar of bfuchs
bfuchs
Flag for United States of America asked on

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?
DatabasesMath / ScienceMicrosoft SQL ServerMongoDB

Avatar of undefined
Last Comment
bfuchs

8/22/2022 - Mon
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)

Is this an Access mdb or accdb ?
SOLUTION
aburr

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
Bitsqueezer

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Enabbar Ocap

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 Ocap

" big Sales promotion
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
CompProbSolv

"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 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 :-).
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
EugeneZ

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
bfuchs

ASKER
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
SOLUTION
Enabbar Ocap

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
SOLUTION
EugeneZ

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Member_2_276102

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?
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
bfuchs

ASKER
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&anchorAnswerId=42079051#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
bfuchs

ASKER
Thank you very much my experts!