Export (0) Print
Expand All

Open, View, and Print a Deadlock File (SQL Server Management Studio)

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

When SQL Server Profiler generates a deadlock, you can capture and save the deadlock information to a file. After you have saved the deadlock file, you can open it in SQL Server Management Studio to view or print.

To open and view a deadlock file

  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 the .xdl file type in the Files of type box. You will now have a filtered list of only deadlock files.

To print a deadlock file

  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 the .xdl file type in the Files of type box. You will now have a filtered list of only deadlock files.

  3. Select the deadlock file you want to print, and click Open.

  4. On the File menu, click Print.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft