Details - Deadlocks

Deadlocks – Details

These cards display blocking details and provide throughput metrics 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 Environment, Instance, Database, Blocker ID, Weekday, and Time of Day.

Deadlock Details

This cards displays the result counts and their aggregate values or subsets at the time of collection for a single Instance in a table format with sortable columns, as follows:

• The Date column displays
• The Deadlock Group ID column displays
• The Database column displays
• The Major Resource Type column displays
• The Total Processes column displays
• The Resources column displays

Hover the cursor over the column headings to sort the list in ascending or descending order.
Click 3-DOT icon at the right in any row to display the Deadlock Details flyout. See the Additional Deadlock Details section for more information.
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, Total 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, Total Processes, and Resources.
  By Major Resource Type:
  Displays a sortable list by Major Resource Type, Total 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, Total Processes, and Resources.

Additional Deadlock Details

The Deadlock Details Flyout displays deadlock details for specific times. Details and XDL Statements can be viewed or copied, as follows:
By Details:
Properties
This card displays the Deadlock Group ID, Database, and Major Resource Type.
XDL Statement
Click the View Statement button to display a flyout with the complete SQL Statement that can be copied or click the Download button to copy the statement for export and further analysis.
Processes and Resources
This card displays a searchable list by Application, Login Name, Isolation Level, SQL Statement, and Input Buffer.

• Hover the cursor over the column headings to sort the list in ascending or descending order.
• To display a pop-up of the entire SQL Statement that can be copied, click on the Input Buffer field.

By XDL Statement:
To display a flyout with the complete SQL Statement, click the XDL Statement link in the header to view and/or copy the statement for export and further analysis.