Post reply

checkpoint for committed transactions..

  • July 23, 2013 at 3:11 pm

    #275565

    Hi

    Can some body say that Is Checkpoint will write pages only from committed transactions...

    please help me on this.

  • July 23, 2013 at 4:28 pm

    #1635157

    Checkpoint writes all modified pages to disk.

    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

  • July 23, 2013 at 4:29 pm

    #1635159

    Hi,

    Checkpoints write all dirty pages to disk.. Whether they're committed or not, if the page has changed in memory, it will get written to disk.

    Cheers

    Vultar

  • July 25, 2013 at 3:58 am

    #1635652

    Here,I would like to know that can we change checkpoint frequency..

    Can the interval be changed ...

    Please advise !!!

  • July 25, 2013 at 6:43 am

    #1635684

    You can indirectly affect the frequency with the recovery interval setting, but there's not usually a good reason to do so.

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

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