Overview - Deadlocks

Deadlocks – Overview

The color-coded stacked lines of the Events Count histogram display the top three (3) deadlocking events by Instance that fall within the specified range of time. The selected date range is displayed in the header of the Events Count card.

To examine individual deadlocking events, the visual display can be changed to further identify when and where deadlocks are occurring the most, as follows:

• Use the calendar widget to change the date range (default is last seven (7) days). The selected range is displayed on the card tool bar.
• Use the time widget to change the time interval displayed (Auto is one (1) hour).
• Use the slide toggles to filter the display by hiding or showing top Instance(s).
• Use the Environment, Instance, Database, Weekday, and Time of Day drop-down Filters to change the visualization. Depending on the filter(s) selected, the histogram will display the top three instances for that criteria.

To view any Anomalies:
Hover the cursor over the Anomalies button in the card tool bar. If anomalies exist, the button will be enabled and display the number of anomalies occurring within the specified date range. Click the button to view the Anomalies pop-up.

• This pop-up displays when the anomaly Started and Ended, the Instance and Database where it occurred, the Actual and Typical counts and a description of the deviation from the expected value.
• To view an anomaly in the dashboard display, click the 3-Dot icon for that row and click View Anomaly. The histogram will now display only the instance with the anomaly highlighted for further investigation.
  NOTE: The data displayed in the Events Count and Deadlock Groups cards can also be further focused using Slicers. See the Slicers section for more information.

Slicers

To filter the data in the dashboard displays, click the Slicer icon [ ///] to the right of the Events Count card. Selections made in the Slicer is reflected in the Filters drop-downs at the top of the screen. The Slicer panel includes filters for:
Top Instances
Where the overview displays only the top three (3) instances, this slicer displays a sortable list of all Instances by Counts.
Top Databases
Displays a list of
Top Object Names
Displays Object Names
Top SQL Statements
Displays Top SQL Statements

Events Count

The histogram in this card displays the top three (3) Deadlocking events by Instance that fall within the specified range of time. To highlight data points, hover the cursor over the stacked, color-coded lines:

• Displays the average number of blocks over the time range below the slide toggles for each top Instance.
• The marker pop-up will display the number of deadlocking events by date for the selected Instance(s). These values are also displayed below the slide toggles along with totals and averages based on percentage contribution.
• To concentrate the display on a specific time range, using the left button, select the block of time by dragging the cursor over the section of the display. The histogram will display only that time range refinement.
  The data displayed can be further filtered using the Time and Day overlays, as follows:
  Time and Day Overlays
  To focus the display by the day of the week or by time of day, click the checkbox for the desired day or time. To hide the Day and Time cards, click Collapse Overlays below the histogram. Only one overlay can be applied at a time.
  Blocking by Day of Week
• Sunday – Saturday
• Click the checkbox to reset Events Count card to display only that day of week.
  Blocking by Time of Day
• 00:40 – 20:00-24:00
• Click the checkbox to reset Events Count card to display only that time of day.

Deadlock Groups

This card groups result-sets in a searchable table format with sortable columns, as follows.

• The Deadlock Group ID column displays
• The Instance column displays
• The Database column displays
• The Events column displays
• The First Date column displays
• The Last Date 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 view additional blocking chain details. See the View Details section for more information.
  Deadlocking data can be further focused by using the Group By drop-down menu, as follows.
  By Instance:
  Displays a sortable list by Instance, Events, First Date, and Last Date.
• Click the arrow [>] to the left of the row to display Deadlock information further by Deadlock Group ID, Database, Events, First Date, and Last Date.

By Database:
Displays a sortable list by Database, Events, and Blocked Statements.

• Click the arrow [>] to the left of the row to display Deadlock information further by Deadlock Group ID, Instance, Events, First Date, and Last Date.

To View Blocking Details:

Click the 3-DOT icon at the end of a row to view blocking details. See the Deadlocks – Details section for more information.