sql server死锁_了解SQL Server中的死锁图的XML描述

sql server死锁

介绍 (Introduction)

在我的前两篇文章“ What is a SQL Server Deadlock and 什么是SQL Server死锁”和“ Understanding the graphical representation of the SQL Server Deadlock Graph, I discussed what a deadlock is, how SQL Server handles deadlocks, some tips on how to reduce deadlocks and ultimately what information you can glean by just looking at the graphical representation of the Deadlock Graph. In this article, I will look at what information is available in the XML description of the Deadlock Graph. The XML contains information which is not visible in the graphical representation of the Deadlock Graph, which makes it necessary for us to look at the XML description. 了解SQL Server死锁图的图形表示”中 ，我讨论了什么是死锁，SQL Server如何处理死锁，有关如何减少死锁的一些技巧以及最终可以获取的信息。通过查看“死锁图”的图形表示即可收集。 在本文中，我将研究“死锁图”的XML描述中提供了哪些信息。 XML包含在死锁图的图形表示中不可见的信息，这使我们有必要查看XML描述。

从死锁图中提取XML描述 (Extracting the XML Description from the Deadlock Graph)

根据捕获死锁图的方式，您可以通过多种方式查看XML文本。

1. 
   Figure 1: Deadlock XML in notepad 图1：记事本中的死锁XML
2. 
   Figure 2: Deadlock Graph as XML in SSMS 图2：SSMS中作为XML的死锁图
3. 
   Figure 3: Double click to get XML report 图3：双击以获取XML报告

了解XML (Understanding the XML)

死锁XML由3个部分组成：

• The victim list
  受害者名单
• The process list and
  流程清单和
• The Resource list
  资源清单

受害者名单 (The victim list