title | description | author | ms.author | ms.reviewer | ms.date | ms.service | ms.subservice | ms.topic | helpviewer_keywords | monikerRange | ||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Open, view, print deadlock file (SSMS) |
Learn how to capture deadlock information that SQL Server Profiler generates and view it in SQL Server Management Studio. |
MikeRayMSFT |
mikeray |
randolphwest |
03/01/2017 |
sql |
performance |
conceptual |
|
=azuresqldb-current||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance] When [!INCLUDEssSqlProfiler] generates a deadlock, you can capture and save the deadlock information to a file. After you've saved the deadlock file, you can open it in [!INCLUDEssManStudioFull] to view it or print it.
-
On the File menu in [!INCLUDEssManStudioFull], point to Open, and then select File.
-
In the Open File dialog box, select the .xdl file type in the Files of type box. You now have a filtered list of only deadlock files.
-
On the File menu in [!INCLUDEssManStudioFull], point to Open, and then select File.
-
In the Open File dialog box, select the .xdl file type in the Files of type box. You now have a filtered list of only deadlock files.
-
Select the deadlock file you want to print, and select Open.
-
On the File menu, select Print.