Page History
...
| Tip |
|---|
You can use the History Browser to view past performance and go back to the point in time to view the sessions involved with the blocking alerts you receive. |
Navigate through the blocking tree to find sessions that cause blocks, and then either trace sessions to find out what is causing the blocks or stop the session to have it removed. To trace a blocked session or lead blocker select it from the list and click Trace Session. To stop a blocked session, or lead blocker, select it from the list , and click Kill Session.
| Tip |
|---|
Deadlocks have no lead blockers and are circular in nature. For this reason, SQL Diagnostic Manager does not display deadlocks in the Blocking Tree but does display instances of deadlocks in the Blocking Chart. In addition, SQL Diagnostic Manager does not count self-blocking sessions as blocked or blocking sessions. |
...
- Overview of the session, including the CPU Time, Row Count, Lock Wait Timeout, Physical Reads and Write metrics.
- Last Command executed.
- All the SQL Server statements.
Blocking chart
The Blocking chart displays the number of blocked sessions, lead blockers, and total deadlocks at a given point in time. The total deadlocks represent the total number of deadlocks that have occurred since the last time the pane was refreshed.
...