Extended Events in Production: Series Contents

Five Extended Events sessions for production troubleshooting, each with the T-SQL to capture the events and read the results.

A woman astronomer aims a telescope at a night sky while streaks of light fall into a row of glowing coloured jars.

The series covers deadlock graphs ranked by repeat offender, blocked process reports traced to the blocker, a lightweight error audit, mining the system_health session that every instance already runs, and a filtered session that captures only slow file I/O.

  1. From Deadlock Graph to Repeat Offender: A Production Extended Events Pipeline
  2. Blocked Process Reports: From Capture to Root Cause
  3. A Lightweight Error Audit with Extended Events
  4. Mining the system_health Session You Already Have
  5. Catching Slow File I/O with a Filtered Extended Events Session

Questions or corrections are welcome on Bluesky or LinkedIn. See all series on this blog.