Post reply

Need to find the autogrowth rate of all db transaction logs

  • June 12, 2014 at 11:20 am

    #292344

    Anyone know how to systematically query and return the transaction log autogrowth rate? Any help is appreciated. Thanks

  • June 12, 2014 at 11:28 am

    #1721187

    I would think you could use this article[/url] and use a job to write daily to a table... You could just need to grab the date the records were added using GETDATE inside your stored procedure.

  • June 12, 2014 at 11:37 am

    #1721190

    Here is the issue in more detail. Some of our databases are creating excessive amounts of VLFs when the logs grow. Then when the cluster fails over, the recovery time is extra long because of the VLFs. So I shrink the transaction logs down, resize, and the next week the VLFs are through the roof again. I read a few articles that states the growth rate of 4gb to be a bug in sql server. The end result being high VLF counts.

    The databases that have the excessive recovery time all have trans log autogrowth rates of 4gb. So I'm on a mission to find the trans logs in the enterprise via our CMS which have this same autogrowth rate.

  • June 12, 2014 at 12:51 pm

    #1721212

    Found out my own answer.

    info on sys.database_files growth * 8 / 1024 = 4096

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

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