Details - Blocking

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

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, Blocker ID, Weekday, Time of Day, and Tag.

Blocking Details

This card 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 Blocker ID column displays the ID number for the blocking chain.
  • The Session ID column displays the SPID for the lead blocker for the individual blocking event.
  • The Start Time column displays the start date and time for the blocking event.
  • The End Time column displays the end date and time for the blocking event.
  • The Object column displays the object the blocking SQL statement belongs to.
  • The Lead Blocker column displays the SQL Statement (if available), a Sleeping Transaction indicator if the blocking was caused by a sleeping session with an open transaction, or rarely a N/A indicator if the statement was not available from the data source.
  • The Blocking Impact column displays the cumulative wait time across all blocked victims for this event.
  • The Blocking Victims column displays the number of SPIDs blocked by this event.

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

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

  • By Blocker ID: Displays a sortable list by Blocker ID, Blocking Impact, and Blocking Victims.

    • Click the arrow [>] to the left of the row to see details for a specific database by Date, Database, Lead Blocker, Wait Time, Wait Resource, Total Victims, and Blocker Wait Time (ms).

  • By Lead Blocker: Displays a sortable list by Lead Blocker, Blocking Impact, and Blocking Victims).

    • Click the arrow [>] to the left of the row to see details for a specific status by Date, Blocker ID, Database, Wait Time, Wait Resource, Total Victims, and Blocker Wait Time (ms).

Click on a row to display the Blocking Details flyout for more detailed blocking data. See the Lead Blocker section for more information.

To display a pop-up of the SQL Statement that can be copied, click on the Lead Blocker field.

Blocking Details Flyout

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

The Properties card displays the Beginning and ending Date and Time for the event, Instance, Database, Object, Blocker ID, Blocking Impact, and Blocking Victims.

The Lead Blocker card displays the SQL statement being executed by the lead blocker with buttons to copy to clipboard or view full-screen.

The lower card is broken into tabs for Resources, Wait Statistics, and Application.

The Resources tab displays a table with columns for Lead Blocker Indicator, Session ID, CPU, IO, Parallel Threads, Granted Memory, Object, and SQL Statement for each Session involved in the blocking chain.

The Wait Statistics tab displays a table with columns for Lead Blocker Indicator, Session ID, Wait Type, Wait Resource, Wait Time, Object, and SQL Statement for each Session involved in the blocking chain.

The Application tab displays a table with columns for Lead Blocker Indicator, Session ID, Host, Login, Program (as passed in the connection string), Object, and SQL Statement for each Session involved in the blocking chain.