Page History
The Sessions tab of the single instance dashboard allows you to quickly view key diagnostic statistics for sessions on your SQL Server instance and contains the Overview and Session Graphs views. Click image to view full size.
Overview
The Sessions > Overview tab contains the following information:
- Session ID
- Host
- Database
- Status
- Open transactions
- Command
- Application
- Wait time (ms)
- Wait type
- Wait resources
- CPU (ms)
- CPU Delta (ms)
- Physical I/O
- Memory
- Login time
- Last Batch
- Blocked by
- Blocking
- Blocking count
- Net address
- Net library
- Version store elapsed (sec)
...
...
...
Session Graphs
The Sessions > Sessions Graphs tab contains the following charts (Click image to view full size):
Response Time (ms)
...
SQL Diagnostic Manager provides three paths to access the Sessions tab. The first access path is by clicking on the Response Time chart (ms) of the single instance dashboard, and you are directed to the Sessions > Overview tab. The second access path is by selecting the Sessions tab of the single instance dashboard. You can also click on an alert that belongs to the Sessions category in the Active alerts panel of the main dashboard.
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >