Post reply

Transaction Log

  • August 9, 2013 at 2:47 pm

    #276858

    One of our databases transaction log file growing larger month by month.Before I increase the disk space I would like to understand is there way we can keep the transaction log file minimal other than shrinking.

    However, data is increasing I belive cause log file to grow.Could you please elobrate what other things can impact the trnasaction log file gowth other than maintenance plans etc.How should I do analysis for the disk space recommendations?

    Thanks and appreciated!

  • August 9, 2013 at 3:15 pm

    #1640297

    Take a read through these

    http://www.sqlservercentral.com/articles/Administration/64582/

    http://www.sqlservercentral.com/articles/Transaction+Logs/72488/

    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

  • August 13, 2013 at 9:22 am

    #1640995

    Thanks! Any more suggestions?

  • August 13, 2013 at 9:39 am

    #1641013

    Did you read the articles?

    Any suggestions on exactly what specifically (since the articles explain log reuse and reasons why it might not be reused)?

    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

  • August 13, 2013 at 9:43 am

    #1641017

    I read the nice artice and thanks for sharing that.However, i am not able to decide the additional disk space i should ask for keeping in mind the log grwoth? Your help is appreciated.

  • August 13, 2013 at 9:48 am

    #1641023

    Why is the log growing? Logs should reach a steady spot where they don't grow any further, so what is causing your log to grow continuously?

    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

  • August 13, 2013 at 10:13 am

    #1641035

    Log growth happening during the maintenance window.Probabily new indexes or new addition of data. Question i have is we are running out of disk space.I need to request for additional space.

    Thanks

  • August 13, 2013 at 1:14 pm

    #1641097

    What is the recovery model of the database? If it is full recovery, how often are you running transaction log backups? Are you shrinking the log files at any time?

    If the transaction log is continuously growing then you need to identify why it is growing and resolve that issue. If the reason it is growing is because the system is growing, then you need to identify how fast it is growing - trend that growth over the next year and determine how much space you will need on the drive to support that growth. Once you have that - then you can request the additional space.

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

Viewing 8 posts - 1 through 7 (of 7 total)

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