Post reply

Difference between Commit and checkpoint

  • April 10, 2014 at 3:39 pm

    #287523

    Hi DBA Experts,

    After a couple of research i came to know difference between commit and checkpoint..

    According to my understanding

    even if we commit the transaction in sql server it will not mark the changes in disk instead it will mark the changes in memory.... and the changes occurred in memory after commit is considered as Dirty pages....and when ever we issue the check point all these dirty pages are written to the disk...In the whole process till checkpoint is issued the particular transaction will be in active part of log.

    Correct me if anything goes wrong...

    Your feedback is required.

    Thanks

    Sampath

    Regards,
    SAM
    ***Share your knowledge.It’s a way to achieve immortality----Dalai Lama***

  • April 10, 2014 at 3:44 pm

    #1705065

    Pretty much.

    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