Andreas Wolter • 3/31/2015

How to import Extended Events session event_file target and parse deadlock-graph

This article provides a detailed tutorial on leveraging SQL Server's Extended Events, specifically the system_health session, to capture deadlock events (error 1205). It explains methods to read data from event_file and ring_buffer targets using T-SQL and XQuery, comparing it to older tracing techniques like SQL Trace and trace flags for more efficient deadlock analysis.

0 comments

#SQL Server #Extended Events #Deadlock Analysis