Mining the system_health Session You Already Have
The system_health session runs by default and writes .xel files. Read the event file, shred the XML, and mine the diagnostics on disk.
A Lightweight Error Audit with Extended Events
Capture error_reported in Extended Events, filter the backup and informational noise at the session, and triage real errors by severity.
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.
Mimic Production in Development
Attempting to debug production performance problems in your development environment can be problematic in many ways, leading to a frustrating troubleshooting experience. One very common situation is the resources on the development environment are substantially…