Post reply

Transaction Log auto-growth

  • July 8, 2014 at 1:42 pm

    #293072

    I have been reading about optimizing the transaction log and how important it is to get the right value for auto-growth, however I have not found any way to check what it is currently or to change it once it's been set.

    Is it possible (or advisable) to change transaction log auto-growth after the database has been created?

    How do you look at what the auto-growth is (presumably it's 10% because it has not been changed)?

  • July 8, 2014 at 1:58 pm

    #1727876

    Object explorer. Right click the DB, select the Files tab. Yes, it is advisable to change it if badly set.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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