Skip to content

Latest commit

 

History

History
41 lines (30 loc) · 1.79 KB

File metadata and controls

41 lines (30 loc) · 1.79 KB
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
deadlocks [SQL Server], printing files
deadlocks [SQL Server], opening files
opening deadlock files
printing deadlock files
ms.assetid 5061b13f-2cb7-457a-b8d0-fbd437b510ab
author MikeRayMSFT
ms.author mikeray
manager craigg

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

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.

To open and view a deadlock file

  1. On the File menu in [!INCLUDEssManStudioFull], 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 [!INCLUDEssManStudioFull], 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.

See Also

Save Deadlock Graphs (SQL Server Profiler)