The Sessions panel tracks the performance of the active and blocked sessions running on your monitored SQL Server. Unexpected spikes in the number of concurrent blocked sessions may warn you about the beginning of a serious performance issue. Chronically high blocked and deadlocked sessions are a significant performance concern. For additional information, see how to get the sessions performance summary.
Activity & Blocking chart
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. |
Client Computers gauge
The Client Computers gauge displays the total number of unique client computers connected to the SQL Server instance.
Available alerts
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >