SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

How to open and view a deadlock graph .xdl file with SSMS ?

How to open and view a deadlock .xdl file with SSMS ?

Solution 1 :

  1. On the File menu in SQL Server Management Studio, point to Open, and then click File.
  2. In the Open File dialog box, select your .xdl file & click open.

Solution 2 :

  1. Go to the directory, you have saved your deadlock graph .xdl file.
  2. Right click on .xdl file > Go to Open With Option > Select SQL Server Management Studio


I, Rohit Garg, am working as Consultant in IT Company. I am having an around 5 years of experience in MSSQL server & other Microsoft technologies. I am working as DBA in Microsoft SQL Server from last 5 years in e-Commerce, Telecom, Finance domain. In this tenure, I got a chance of working as Database administrator, Developer and trainer on SQL server 2000 to SQL Server 2012. I am holding Master’s degree in Computer Science along with certification in SQL Server & .Net. I like to learn new things by hand-on experience on regular basis. This journey is so far is delightful & valuable with the addition of wonderful friends.


Leave a comment on the original post [mssqlfun.com, opens in a new window]

Loading comments...