Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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 Get sessions performance summary.

Anchor
1484272283
1484272283
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.

Anchor
1519281723
1519281723
Client Computers gauge

The Client Computers gauge displays the total number of unique client computers connected to the SQL Server instance.

Available alerts


Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
| 

...

Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse
SQL  Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >

 

...