Details - Deadlocks

  • Updated on Apr 4, 2025
  • Published on Sep 28, 2023
  • 2 minute(s) read
Prev Next

Deadlocks Details

This card displays blocking details for a single Instance. View the details for a previously selected Instance, or when prompted, select a specific Instance from the Instance drop-down list. The selected Instance name will be displayed.

  • Use the drop-down menus to further filter the list by Database, Deadlock Group ID, Weekday, Time of Day, and Tag.

Deadlock Details

This card displays the individual deadlock events for a single Instance in a table format with sortable columns, as follows:

  • The Date Column Displays the date and time of the deadlock event.
  • The Deadlock Group ID column displays the ID number for the deadlock.
  • The Database column displays the Database context for the deadlock event.
  • The Major Resource Type column displays the locking level (usally KEY or PAGE) involved in the deadlock.
  • The Processes column displays the count of processes involved in the deadlock event.
  • The Resources column displays the count of resources involved in the deadlock event.

Note: Click on column headings to sort the list in ascending or descending order.

This data on Deadlocks can be further examined by using the Group By drop-down menu, as follows:

  • By Database: Displays a sortable list by Database, Processes and Resources.

    • Click the arrow [>] to the left of the row to see details for a specific database by Date, Deadlock Group ID, Major Resource Type, Processes, and Resources.

  • By Major Resource Type: Displays a sortable list by Major Resource Type, Processes and Resources.

    • Click the arrow [>] to the left of the row to see details for a specific database by Date, Deadlock Group ID, Database, Processes, and Resources.

Click on a row to display the Deadlock Details flyout for more detailed Deadlock data. See the Deadlock Details Flyout section for more information.

Deadlock Details Flyout

This flyout displays more details for the selected Deadlock event and is made up of Three cards:

The Properties card displays the Date and Time for the event, Instance, Database, Object, Deadlock Group ID, Major Resource Name, and Major Resource Type.

The XDL Statement card displays the XDL statement (Deadlock XML) for the deadlock. It has icons for Full Screen and Copy to Clipboard. This XDL file can be opened in other tools like SQL Server Management Studio to view the visualization.

The lower card is broken into tabs for Processes and Resources.

The Processes tab displays a table with columns for Application, Host, Login, Isolation Level, SQL Statement, and Input Buffer for each process involved in the deadlock.

The Resources tab displays a table with columns for Object Name, Index Name, Resource Type, and Meta Data Lock Info for each resource involved in the deadlock.