You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

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.

Blocked Sessions

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 > >

 

 

  • No labels