2

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.

3
  • This will help you dba.stackexchange.com/a/40964/8783
    – Kin Shah
    Commented Jun 27, 2013 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
    Commented Jun 27, 2013 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
    Commented Jun 27, 2013 at 16:53

0

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.