Check Point

Question

Post reply

Check Point

Oracle_91

SSChampion

Points: 14548
More actions
October 31, 2009 at 8:59 pm

#142872

Hi All,
Need some information.
When does a check point occurs and what is going to happen internally, whenever a check point occurred.
Thank You.

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

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

@SQLNumpty SSCrazy Points: 2940 More actions · Answer 1

This should be all you need.

http://msdn.microsoft.com/en-us/library/ms188748.aspx

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

http://sqlinthewild.co.za/index.php/2009/06/26/the-lazy-writer-and-the-checkpoint/

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

Oracle_91 SSChampion Points: 14548 More actions · Answer 3

Oracle_91

SSChampion

Points: 14548

November 1, 2009 at 1:31 pm

#1073620

Thank You!