SQL Diagnostic Manager allows you to view a wide range of information collected for your monitored SQL Server instances hosted on Amazon RDS and Microsoft SQL Azure. However, the following information and metric data are not available yet:
For monitored SQL Server instances hosted on Amazon RDS:
| SQL Diagnostic Manager area | Information and metric data not collected by Amazon RDS |
|---|---|
| Overview > Details | Available Memory |
Data File Space used | |
Disk Queue Length | |
Disk Time (Percent) | |
OS CPU Privileged Activity | |
OS CPU User Time | |
OS Total Processor Activity | |
Pages Per Second | |
Physical Memory | |
Procedure Cache Size | |
Processor Queue Length | |
Sql Memory Used Percent | |
Used Memory(Percent) | |
| Sessions > Details | Blocked by |
| Execution Context | |
| Resource | |
| Wait type |
For monitored SQL Server instances hosted on Microsoft SQL Azure:
| SQL Diagnostic Manager area | Information and metric data not collected by Microsoft SQL Azure |
|---|---|
| Overview > Details
| Available Memory |
Batches | |
Batches Per Second | |
Blocked Sessions | |
Buffer Cache Hit Ratio | |
Buffer Cache Size | |
Checkpoint Wrights | |
Checkpoint Wrights Per Second | |
Client Computers | |
Connections | |
Connections Per Second | |
Data File Count | |
Data File Space Allocated | |
Data File Space used | |
Database Count | |
Disk Queue Length | |
Disk Time (Percent) | |
Full Scans | |
Full Scans Per Second | |
Lazy Writer Writes | |
Lazy Writer Writes Per Second | |
Lead Blockers | |
Lock Waits | |
Lock Waits Per Second | |
Log File Count | |
Log File Space Allocated | |
Log File Space Used | |
Log Flushes | |
Log Flushes Per Second | |
Maintenance Mode | |
OLE Automation Status | |
Open Transactions | |
OS CPU Privileged Activity | |
OS CPU User Time | |
OS Metrics Availability | |
OS Total Processor Activity | |
Packet Errors | |
Packet Errors Per Second | |
Packets Received | |
Packets Received Per Second | |
Packets Sent | |
Packets Sent Per Second | |
Page Life Expectancy | |
Page Lookups Per Second | |
Page Lookups Per Second | |
Page Reads | |
Page Reads Per Second | |
Page Splits | |
Page Splits Per Second | |
Page Writes | |
Page Writes Per Second | |
Pages Per Second | |
Physical Memory | |
Procedure Cache Hit ratio | |
Procedure Cache Size | |
Processor Queue Length | |
Read Ahead Pages | |
Read Ahead Pages Per Second | |
Read Write Errors | |
Response Time | |
Running Since | |
Server Version | |
Sql Compilations | |
Sql Compilations Per Second | |
Sql CPU Activity | |
Sql Memory Allocated | |
Sql Memory Used | |
Sql Memory Used Percent | |
Sql Recompilations | |
Sql Recompilations Per Second | |
System Processes | |
System processes Consuming CPU | |
Used Memory(Percent) | |
User Connections Percent | |
User Processes | |
User Processes Consuming CPU | |
WMI Service Status | |
Workfiles Created | |
Workfiles Created Per Second | |
Worktables Created | |
Worktables Created Per Second | |
| Sessions > Summary | Average Wait Time |
Deadlocks | |
Requests | |
Timeouts | |
Waits | |
Wait Time | |
| Sessions > Details | Blocked by |
Net library | |
| Network Address | |
| Open Transactions | |
| Wait type |