Post reply

manage data file growth

  • February 15, 2013 at 4:20 pm

    #274339

    Hi,

    database current size is 24 GB and is growing approx. 30 MB per day.

    Database data file is set to unrestricted growth by 1 MB and log file By 10 percent, restricted growth to 2097152 MB. SQL is using 1.56 GB out of 4 GB

    and we have 146 GB free space on drive where database data and log files resides.

    we are getting alerts like...Databases - Dynamic Data File Growths Remaining: Data file growths remaining could not be evaluated because OS data is not available.

    Just wondering how much to set data file growth option? Please advise.

  • February 15, 2013 at 4:44 pm

    #1588560

    30MB per day * 365 days is rougly 11GB. Set your current database size to 24GB (current size) + 11GB (anticipated growth) for a total of 35GB and be done with it.

    Also, change your default growth setting from what they are to something like 100MB/100MB. NEVER grow by percent. Frags the hell out of the database and underlying disk when the DB is small and growing and can cause way too much growth when the DB is larger.

    --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)

Viewing 2 posts - 1 through 1 (of 1 total)

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