Post reply

8620 VLFs for one of many databases in the Server

  • December 17, 2015 at 4:34 am

    #1846514

    Do you know that that batch job won't run again?

    Do you know how big your TLog is likely to get? If so, size for that (or an appreciable fraction of that), and set the growth factors accordingly.

    Thomas Rushton
    blog: https://thelonedba.wordpress.com

  • December 17, 2015 at 6:08 am

    #1846533

    New Born DBA (12/16/2015)

    I am trying to change the Log Auto-Growth setting to 8 GB,

    even with fast disks this will take time to initialise the space.

    You'll likely get timeout issues with your batch job before the file grows. As Thomas has said, set the files initial size to what will be required and catch any further space increases with a sensible autogrowth setting

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

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

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