Page History

The Sessions tab contains the following views:

• Summary view where you : You can view charts for each Sessions statistic. The , the following charts display in the Summary tab:
  • Response Time
  • Sessions
  • Lock Statistics: Average Wait Time, Deadlocks, Requests, Timeouts, Waits, and Wait Time
  • Blocked Sessions
• Details view that lets : Allows you to create charts with the specific data items you need.
• Locks view that allows : Allows you to create charts based on each lock present on your SQL ServerSQL Server.
• Blocking view where : Allows you can to create charts specific to all the Blocking sessions.

Image Added

The Sessions tab provides the following options:

• The ability to diagnose performance bottlenecks caused by blocking or locked sessions.
• The ability to trace specific sessions to see why the session may be blocking or locked.
• The ability to kill sessions to improve system performance.

Access the Sessions tab

SQL Diagnostic Manager provides two paths to access Access the Sessions tab . The first access path is by clicking the appropriate monitored SQL Server SQL Server instance , and then clicking the Sessions tab. The second access path is by expanding the Servers tree, and then clicking Sessions for the appropriate instance.

Alerts associated with the Sessions tab

...

Provides the CPU time (in seconds) used by a SQL Server SQL Server sessions.

SQL Server Response Time (Milliseconds)

...