I’ve previously blogged about the changes to the xml_deadlock_report in Extended Events to support multi-victim deadlock analysis. One of the side effects of this change was that the XML document for the deadlock report had to be modified to be able to accommodate multiple victim processes in the graph. As a result of this, the [...]
Jonathan Kehayias
The Rambling DBA
Graphically Viewing Extended Events Deadlock Graphs
Posted on: February 13, 2013 12:25 pm
SQL Rally Presentation – Deadlocking for Mere Mortals
Posted on: May 18, 2011 10:42 am
The first SQL Rally was held last week in Orlando, FL, and I had the honor of being selected for one of the spotlight sessions by the community in the DBA track. SQL Rally was a different experience from the regular PASS Summit; it wasn’t anywhere as big as the normal summit, but it was [...]
Extended Events xml_deadlock_report and Multi-Victim Deadlocks
Posted on: May 27, 2009 10:32 am
At the beginning of the year, I wrote an article titled Retrieving Deadlock Graphs with SQL Server 2008 Extended Events that detailed how to use the default system_health session to retrieve deadlock graphs from SQL Server 2008 without having to use SQL Profiler, SQL Trace or enabling a Trace flag on the SQL Server. In [...]
