Page History
...
| Tip |
|---|
To access similar information on the Blocking view , select a specific SQL Server instance, point to Sessions, and then select the Blocking ribbon. |
Blocking Sessions Report
The Blocking Sessions Report displays blocking and blocked sessions' information. To access the Blocking Sessions Report in the Alert view, select the Show Block Details option in the right-click context menu.
...
| Tip |
|---|
To retrieve the blocking sessions report for SQL Diagnostic Manager, select the "Non-Query activities>Capture Blocking (SQL 2005+)" check box in the Activity Monitor Tab. |
Reduce blocked sessions wait time
If you experience more than one blocked session on an average day, your site may experience one of the following issues:
...