Catching Slow File I/O with a Filtered Extended Events Session
file_read_completed and file_write_completed fire on every I/O. Filter on duration to capture only the slow ones, then shred to name the file.
Blocked Process Reports: From Capture to Root Cause
Enable the blocked process threshold, capture blocked_process_report in Extended Events, and shred the XML into a blocker and blocked view.
From Deadlock Graph to Repeat Offender: A Production Extended Events Pipeline
Capture xml_deadlock_report in an Extended Events session, persist it past the ring buffer, and rank the repeat-offender procedures in T-SQL.