Page History
...
The Activity and Blocking chart shows the total number of active sessions on your monitored SQL Server instance and any blocking or deadlocks that may occur between sessions.
Metric | Why it is important |
---|---|
Active | Indicates the number of active sessions on the SQL Server instance. |
Indicates the number of sessions on the SQL Server instance being blocked by other sessions holding requested locks. | |
Lead Blockers | Indicates sessions that block at least one session, which can then block other sessions. |
Total Deadlocks | Indicates the total number of deadlocks on the SQL Server instance. A deadlock has no lead blocker and is circular in nature. |
Anchor | ||||
---|---|---|---|---|
|
...
Scroll pdf ignore |
---|
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > > |