| title | Open, View, and Print a Deadlock File (SQL Server Management Studio) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom | |||||
| ms.date | 06/13/2017 | ||||
| ms.prod | sql-server-2014 | ||||
| ms.reviewer | |||||
| ms.technology | performance | ||||
| ms.topic | conceptual | ||||
| helpviewer_keywords |
|
||||
| ms.assetid | 5061b13f-2cb7-457a-b8d0-fbd437b510ab | ||||
| author | MikeRayMSFT | ||||
| ms.author | mikeray | ||||
| manager | craigg |
When [!INCLUDEssSqlProfiler] 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 [!INCLUDEssManStudioFull] to view or print.
-
On the File menu in [!INCLUDEssManStudioFull], point to Open, and then click File.
-
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.
-
On the File menu in [!INCLUDEssManStudioFull], point to Open, and then click File.
-
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.
-
Select the deadlock file you want to print, and click Open.
-
On the File menu, click Print.