Database Blocking Tree Window Features
From the Database Blocking Tree window you can expand the tree of a blocking session to see the sessions it is blocking.
From the Database Sessions window, you can view:
- Session ID: the Session ID of the sessions causing the block, and the sessions being blocked
- Client: the names of the machines where the session is blocked
- User: the user of the blocked session
- Query: the query that is blocked or causing the block
- Blocked Object: the object that is blocked
- First occurrence of block: the time that the block first occurred in the specified time range
- Block Duration: the amount of time that the session was blocked or causing the block