Last Post 27 Nov 2009 03:29 AM by subpra1977. 0 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

27 Nov 2009 03:29 AM
Hi All,

I was observing the wait_type CHECKPOINT_QUEUE using the DMV SYS.DM_OS_WAITING_TASK.

As per BOL it is documented that CHECKPOINT_QUEUE "Occurs while the checkpoint task is waiting for the next checkpoint request."

As all of you know that the Full Bakcup should initiate a Checkpoint on the database. and i could see there is a check point happend due to full backup from the DBCC LOG command. But the CHECKPOINT_QUEUE wait type still continuous to be growing (Did not reset after the Full Backup)

Any thoughts on this?

Acceptable Use Policy