Post reply

Checkpoint

  • April 4, 2008 at 3:07 am

    #154257

    Hi,

    1.What is the use of the statement Truncate Log on checkpoint

    2.What is the difference between the Lazywriter and the checkpoint process.

    Went through BOL but was not able to get it though.

  • April 4, 2008 at 3:29 am

    #798279

    1) It's old syntax (I think it's deprecated) with the same behaviour as Simple recovery mode.

    2) Lazy writer writes dirty pages to disk based on memory pressure. Checkpoint runs from time to time and writes all dirty pages to disk in order to keep the recovery time of a database down.

    The interval between checkpoints depends on the activity in the DB and the time permitted to recover teh DB in case of a service restart.

    As a rough rule of thumb, if the lazy writer writes more pages/sec than th checkpointer does, you may have a memory botleneck.

    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

  • April 4, 2008 at 5:12 am

    #798314

    Thanks for your reply...

    What is the effetc of this statement when we apply the final t- log back up?

  • April 4, 2008 at 5:14 am

    #798315

    Which statement?

    Applying tran logs in a log shipping scenario? Disaster recovery?

    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 4 posts - 1 through 3 (of 3 total)

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