Post reply

Best practice for user created database log file autogrowth settings

  • September 9, 2017 at 6:45 am

    #402473

    hi,

    Please let me know, what is the best practice for user created database log file autogrowth settings.

    Thanks,
    Babu

  • September 9, 2017 at 7:11 am

    #1958841

    annamsiva.dba - Saturday, September 9, 2017 6:45 AM

    hi,

    Please let me know, what is the best practice for user created database log file autogrowth settings.

    Thanks,
    Babu

    Have a look at this article by Paul Randal
    😎

  • September 11, 2017 at 9:06 am

    #1958955

    +1, use guidance , and you will need to make some decision that is appropriate for your environment

  • September 14, 2017 at 2:17 am

    #1959371

    annamsiva.dba - Saturday, September 9, 2017 6:45 AM

    hi,

    Please let me know, what is the best practice for user created database log file autogrowth settings.

    Thanks,
    Babu

    Application stats like how many anticipated transactions occurring in a day , and scalability etc . As a best practice from Microsoft setting percentage as growth type to be avoided , recommending to keep it value based.

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

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