Currently the Dead Lock drill down only displays two columns (Data and Victim SPID) with XML data at the bottom for graph display. The graph is accessed by the View Graphs ribbon which will display the XML data in SQL Server Management Studio as a graph.
If there are 10 dead locks that happened, each of the dead locks must be clicked on one at a time and then view the graph individually. This can get tedious and it doesn't give an overall picture on all the dead locks.
The Dead Lock drill down should show more than two columns. All the data in the XML should be columns in Dead Lock drill down. For example, Object Name, Owner ID, Page ID, etc.
© ALL RIGHTS RESERVED. 利用規約 プライバシー Cookie Preference Center