Page History
...
To access the History Browser, click the History Browser button on a supported view, such as Overview > Dashboard. For more information, click History Browser Range.
Select a specific snapshot in time in the History Browser
...
The following table displays a list of alerts that provide an associated view in SQL Diagnostic Manager.
Alert | Associated View |
|---|---|
Average Disk Milliseconds Per Read | Resources |
Average Disk Milliseconds Per Transfer | Resources |
Average Disk Milliseconds Per Write | Resources |
Blocked Sessions (Count) | Sessions |
Blocking Session Wait Time (Seconds) | Sessions |
Client Computers (Count) | Sessions |
Databases Read/Write Errors Occurred | Databases |
Disk Reads Per Second | Resources |
Disk Transfers Per Second | Resources |
Disk Writes Per Second | Resources |
Host CPU Usage (Percent) | Resources |
Host Memory Usage (Percent) | Resources |
Oldest Open Transactions (Minutes) | Sessions |
OS Average Disk Queue Length (Count) | Resources |
OS Average Disk Queue Length Per Disk (Count) | Resources |
OS Disk Time (Percent) | Resources |
OS Disk Time Per Disk (Percent) | Resources |
OS Memory Usage (Percent) | Resources |
OS Paging (Per Second) | Resources |
OS Privileged Time (Percent) | Resources |
OS Processor Queue Length (Count) | Resources |
OS Processor Time (Percent) | Resources |
Page Life Expectancy | Server |
Session CPU Time (Seconds) | Sessions |
SQL Server CPU Usage (Percent) | Resources |
SQL Server Memory Usage (Percent) | Resources |
SQL Server Response Time (Milliseconds) | Sessions |
Tempdb Contention (ms) | Databases |
User Connections (Percent) | Sessions |
VM CPU Usage (Percent) | Resources |
VM Memory Usage (Percent) | Resources |
Views that support historical snapshots
...
- Overview > Dashboard
- Overview > Details
- Overview > Active Alerts
- Sessions > Summary
- Sessions > Details
- Sessions > Locks
- Sessions > Blocking
- Queries > Signature Mode
- Queries > Statement Mode
- Queries > Query History
- Queries > Query Waits
- Resources > Summary
- Resources > CPU
- Resources > Memory
- Resources > Disk
- Resources > File Activity
- Resources > Server Waits
- Databases > Tempdb Summary
- Databases > Availability Group
- Analyze > History
...
| Scroll pdf ignore |
|---|
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > > |