CHECKPOINT_QUEUE

Last Post 27 Nov 2009 03:29 AM by subpra1977. 0 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
subpra1977
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?



You are not authorized to post a reply.

Acceptable Use Policy