database growth

Question

database growth

WhiteLotus

SSChampion

Points: 12120
More actions
October 11, 2016 at 10:03 pm

#318139

Hi
I want to monitor the growth of database size in production , so I run a query which tells me the backup size in 1 month ,
Database size is 45 GB and I notice it grows 20 – 50 MB per day . Do you think it is a big growth ?
As I would need to upload many files in the database in the future
Any feedback are much appreciated
Thank you

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jeff Moden SSC Guru Points: 1003863 More actions · Answer 1

WhiteLotus (10/11/2016)
Hi
I want to monitor the growth of database size in production , so I run a query which tells me the backup size in 1 month ,
Database size is 45 GB and I notice it grows 20 – 50 MB per day . Do you think it is a big growth ?
As I would need to upload many files in the database in the future
Any feedback are much appreciated
Thank you

No. Depending on what you're doing, I don't think that's a big growth.

That, notwithstanding, I would likely develop an archive plan for older data that won't be needed after a period of time.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Grant Fritchey SSC Guru Points: 398690 More actions · Answer 2

It's not big growth, at all. That's .05gb/day. In 50 days, two months, you'll grow 2.5gb. In 500 days, you'll grow 25gb. Storage currently costs about $0.019/gb. To support almost two years worth of growth you'll have to spend $0.475 to buy enough storage to support the current growth rate. My laptop came with a 500gb drive. Surely any machine that's supporting an enterprise database will have enough storage to support 25gb of growth over almost two years. This is absolutely not something I would be worrying about. On the other hand, if you really think your hard drive is going to run out space because of this level of growth, it's time to get a bigger (and probably better) hard drive right now.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

WhiteLotus SSChampion Points: 12120 More actions · Answer 3

Thanks for the feedback . Much appreciated

It is very cheap ! Can you show me the link about the price / product information ?

Many thanks

Grant Fritchey SSC Guru Points: 398690 More actions · Answer 4

WhiteLotus (10/12/2016)
Thanks for the feedback . Much appreciated
It is very cheap ! Can you show me the link about the price / product information ?
Many thanks

I just did a google search for average storage price per gigabyte.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning