February 12, 2009 at 4:49 am
Hi
what is the use check point in SQL sever database?
How to set a check point in SQL Server?
which condition and what are steps should followed for attempt check point?
Please explain it would be helpful for me.
Thanks
February 12, 2009 at 5:52 am
ananda.murugesan (2/12/2009)
Hiwhat is the use check point in SQL sever database?
How to set a check point in SQL Server?
which condition and what are steps should followed for attempt check point?
Please explain it would be helpful for me.
Thanks
Checkpoints write modified pages from the buffer cache to disk. When you make changes, they are not written to disk immediately. Rather, they are kept in memory and checkpointing occurs periodically. You can't set a checkpoint schedule. It's an internal algorithm.
There are also events within SQL Server which will trigger a checkpoint. Things like an alter database, backup log and some others which escape my memory now.
Also, you can run a checkpoint manually, but I've never had cause to actually do this.
February 12, 2009 at 6:45 am
Checkpoints writes all dirty pages for the current database to disk. Dirty pages are pages that are entered in the cache and modified, but not written to the disk yet.
Checkpoints save time during a later recovery by creating a point at which all dirty pages are guaranteed to have been written on the disk
February 12, 2009 at 12:56 pm
http://msdn.microsoft.com/en-us/library/ms188748.aspx
CHECKPOINT (Transact-SQL)
Writes all dirty pages for the current database to disk. Dirty pages are data pages that have been entered into the buffer cache and modified, but not yet written to disk. Checkpoints save time during a later recovery by creating a point at which all dirty pages are guaranteed to have been written to disk.
MJ
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply