From Deadlock Graph to Repeat Offender: A Production Extended Events Pipeline

· by · in

Capture xml_deadlock_report in an Extended Events session, persist it past the ring buffer, and rank the repeat-offender procedures in T-SQL.