Page History
...
The Blocking Sessions Report (Block Reports) displays blocking and blocked sessions’ information (Click image to view full size). To access the Blocking Sessions Report in the Alert view, select the Show Block Details option in the right-click context menu. You can also access the same information on the Blocking View by selecting a specific SQL Server instance, pointing to Sessions, and then selecting the Blocking ribbon.
Gallery | ||
---|---|---|
|
Key information provided for blocking and blocked sessions includes:
Blocking Process Details:
- Session ID
- Host Name
- User Name
- Application
- Database
- Last Batch Started
- Transaction ID
- Open Transactions
Blocked Process Details:
- Session ID
- Host Name
- User Name
- Application
- Database
- Last Batch Started
- Transaction ID
- Open Transactions
- Wait Time (ms)
- Wait Resource
...
The Deadlock Sessions Report (Deadlock Reports) displays deadlock sessions information (Click image to view full size) . To access the Deadlock Sessions Report in the Alert view, select the Show Block Details option in the right-click context menu. You can also access the same information on the Blocking View by selecting a specific SQL Server instance, pointing to Sessions, and then selecting the Blocking ribbon.
Gallery
Key information provided for deadlock sessions includes:
Deadlock Process Details:
- Session ID
- Status
- Host Name
- User Name
- Execution Context
- Application
- Database
- Last Batch Started
- Last Batch Completed
- Last Transaction Started
- Transaction ID
- Transaction Name
- Open Transactions
- Wait Time (ms)
- Wait Type
- Wait Resource
...
Tip |
---|
To retrieve the deadlock sessions report for SQL Diagnostic Manager, select the "Non-Query activities>Capture deadlocks (SQL 2005+)" check box in the Activity Monitor Tab. |
...
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
...