Post reply

database growth

  • 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

  • October 11, 2016 at 11:51 pm

    #1906025

    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)

  • October 12, 2016 at 6:33 am

    #1906092

    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

  • October 12, 2016 at 6:29 pm

    #1906240

    Thanks for the feedback . Much appreciated

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

    Many thanks

  • October 12, 2016 at 8:57 pm

    #1906247

    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

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

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