Post reply

Transaction Log Functionality Question

  • September 3, 2013 at 6:50 am

    #279215

    I know Gail will have the answer, maybe someone else will too.

    I have a database that will fill up the log on the next execution of a specific job. This database & log are on one hard drive. The increased disk space request is already under way, but that takes time.

    In the meantime, I am adding a second log file to the server's other drive where there is some temporary extra space.

    My question is this: When a database has two log files, does it stripe the transaction log data across both files or does it fill one then switch to the other?

    I'm thinking it stripes, but my google fu can't seem to find the definitive answer (I keep getting the basic transaction log articles & BOL links). So I would appreciate any insight you might have on this.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

  • September 3, 2013 at 6:56 am

    #1647016

    Data files are striped. Log files are used sequentially (hence why there is NO performance benefit from multiple log files)

    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

  • September 3, 2013 at 7:25 am

    #1647026

    Thank you for clarifiying that, Gail. I knew I was misunderstanding something.

    I'm not actually looking for performance enhancement. I'm just looking to get this job completed while we're waiting for additional space. I fully intend to remove the secondary log file once we add space to the main drive where the file rests.

    Brandie Tarvin, MCITP Database AdministratorLiveJournal Blog: http://brandietarvin.livejournal.com/[/url]On LinkedIn!, Google+, and Twitter.Freelance Writer: ShadowrunLatchkeys: Nevermore, Latchkeys: The Bootleg War, and Latchkeys: Roscoes in the Night are now available on Nook and Kindle.

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

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