Blocking Sessions
The Blocking Sessions tab displays the current blocking and waiting sessions in a hierarchical display.
-
View detailed information about each blocking session, and view sessions blocked by each blocking session.
-
Inspect or drill down into the SQL involved, to determine the cause of the blocking.
-
Perform several troubleshooting operations, including terminating one or more listed sessions to resolve a waiting session problem.
The hierarchical display nests waiting sessions underneath the session that is blocking them in an easily viewable parent-child relationship. The hierarchy can contain any number of levels to correctly represent the structure of the sessions involved.
The sessions listed include sessions that are waiting for a resource, and sessions that hold a resource that is being waited on that creates a blocking condition.