Post reply

Clearning the transaction log

  • February 4, 2011 at 8:38 am

    #1282513

    The information found on the following blog might be interesting in regards to this VLF question:

    http://ochoco.blogspot.com/2009/03/shrinking-transaction-log-files-in-sql.html

    Thanks for the QoTD,

    Michael

  • February 4, 2011 at 8:41 am

    #1282514

    I picked the correct answer, but possibly for the wrong reason. Maybe someone could comment?

    Consider an unused database with no active transactions. If I either manually issue a CHECKPOINT or stop/restart the server (forcing a CHECKPOINT), but there are no transactions to clear, why would a VLF be cleared?

    Thanks,

    Rich

  • February 4, 2011 at 9:15 am

    #1282535

    rmechaber (2/4/2011)

    Consider an unused database with no active transactions. If I either manually issue a CHECKPOINT or stop/restart the server (forcing a CHECKPOINT), but there are no transactions to clear, why would a VLF be cleared?

    It wouldn't, but that is not what the explination is saying.

    0 or More VLF files will be cleared.

    As in sometimes VLF files are not cleared after a checkpoint.

    Thier are several things that would casue 0 VLF files to be cleared.

  • February 4, 2011 at 2:17 pm

    #1282706

    Thanks for the question Steve!

  • February 4, 2011 at 8:30 pm

    #1282771

    GilaMonster (2/4/2011)

    Tom.Thomson (2/3/2011)

    It will be interesting to see how many manage to get it wrong.

    And how many gripe about Steve's spelling :hehe:

    Yes, Steve can't spell. I completely blame Firefox for the lack of a squiggly in the text box.

  • February 5, 2011 at 9:41 am

    #1282799

    Steve Jones - SSC Editor (2/4/2011)

    GilaMonster (2/4/2011)

    Tom.Thomson (2/3/2011)

    It will be interesting to see how many manage to get it wrong.

    And how many gripe about Steve's spelling :hehe:

    I completely blame Firefox for the lack of a squiggly in the text box.

    Don't they have an add-on for that? 😀 😛

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • February 8, 2011 at 4:15 am

    #1283594

    One more good question with good topic VLF 🙂

    Simple logic, if this statement is True we never encounter LOG FULL in simple recovery. But we do not as it depnd on open transaction.

    Cheers!

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • February 8, 2011 at 12:07 pm

    #1283956

    Great fundamental question.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

Viewing 8 posts - 16 through 23 (of 23 total)

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