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.
SQL Workload Analysis
...
| Info |
|---|
You can launch SQL Workload Analysis from the single instance view and its tabs of the SQLDM web console. The icon Launch SWA located on the top-right side of the screen is available when your instance is registered in SQL Workload Analysis product. |
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)
| Tip | ||
|---|---|---|
|
...
You can export sessions overview information in the following formats: PDF, XLS, or XML. |
Session Graphs
The Sessions > Sessions Graphs tab contains the following charts (Click image to view full size):
...
| Scroll pdf ignore |
|---|
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > > |