I was using extended events to trace checkpoint activity of a database with indirect checkpoints enabled. The event stream looks like this:

enter image description here

And the details of the selected event are:

enter image description here

The description of the selected event is:

Chose to enqueue an incremental checkpoint as we are near our recovery target

It was determined using the following query:

SELECT name, description FROM sys.dm_xe_objects WHERE name LIKE '%checkpoint%' ORDER BY name

I'm trying to better understand how indirect checkpoints work under the covers. What is an incremental checkpoint? What IO patterns will it cause? How does it relate to a "normal" checkpoint?

I have studied the docs about checkpoints but I could not find any information about this.

  • This will help you dba.stackexchange.com/a/40964/8783 – Kin Shah Jun 27 '13 at 16:39
  • @Kin thanks. I found that answer to be helpful but it does not reference the term "incremental". I'd like to understand what exactly an incremental checkpoint does. – usr Jun 27 '13 at 16:46
  • I dont think that it is documented in BOL (atleast I could not find), but other people might help you. – Kin Shah Jun 27 '13 at 16:53

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.