Best practice for user created database log file autogrowth settings

  • hi,

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

    Thanks,
    Babu

  • 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
    😎

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

  • 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