How to generate deadlock graph using XML trace file sql server

Question

How to generate SQL server deadlock graphs from the capture XML deadlocks trace file

Answer 1

1. Copy the XML file to the server where SQL instance is installed.
2. Open SQL server profiler > click on file > Open trace file > change the file type to XML > Select the XML trace file.
   
3. Click on the deadlock graph event in the profiler displayed traces.
   

Answer 2

You should not look at the deadlock graph, but I have never been able to understand it. Also, the graph hides a lot of information about the deadlock, for instance if any process in an active transaction. Look at the raw XML instead.

Answer 3

Hi @siddhardha vadella

How to generate SQL server deadlock graphs from the capture XML deadlocks trace file

Please refer to this article: Understanding the graphical representation of the SQL Server Deadlock Graph.

As Erland answered, the deadlock graphical representation on its own is not always enough. There is some information which is not available just by looking at the graph, which is available in the XML description.

So please refer to this article: Understanding the XML description of the Deadlock Graph.

Best regards,

Cosmog Hong

---

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 4

Or use SSMS to have a look at the deadlock graph:

[https://learn.microsoft.com/en-us/sql/relational-databases/performance/open-view-and-print-a-deadlock-file-sql-server-management-studio?view=sql-server-ver16