Checkpoint Tracking via Extended Events

Checkpoint tracking can be useful when you’re attempting to understand when automatic checkpoints are occurring. Extended Events in SQL Server offer a powerful way to track many events in SQL Server as they happen. This post shows how to setup an Extended Events session for tracking checkpoints. Both automatic, indirect, and manual checkpoints are covered by the session.

checkpoint in a self portrait by Godfrey Kneller

checkpoint in a self portrait by Godfrey Kneller

Use the code in our post on querying the ring buffer to get the data out of this Extended Events session. Alternately, you could simply watch the live data via the Extended Events session monitoring built into SQL Server Management Studio.

Check out the rest of our series on Extended Events.

Ads by Google, Paying the Rent: