Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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.

share|improve this question
    
This will help you dba.stackexchange.com/a/40964/8783 –  Kin 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 Jun 27 '13 at 16:53
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.