I was using extended events to trace checkpoint activity of a database with indirect checkpoints enabled. The event stream looks like this:
And the details of the selected event are:
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.