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.
To have more information on the metrics data that are available for cloud instances, select your preferred option:
- Available metrics for Amazon RDS and Microsoft SQL Azure in SQL Diagnostic Manager.
- Unavailable metrics for Amazon RDS and Microsoft SQL Azure in SQL Diagnostic Manager.
Available metrics for Amazon RDS and Microsoft SQL Azure in SQL Diagnostic Manager
For monitored SQL Server instances hosted on Amazon RDS:
| SQL Diagnostic Manager Area | Collected Metrics by Amazon RDS |
| Sessions -> Summary | Response Time |
| Sessions | |
| Blocked Sessions | |
| Lock Statistics -> Average Wait Time | |
| Lock Statistics -> Deadlocks | |
| Lock Statistics -> Requests | |
| Lock Statistics -> Timeouts | |
| Lock Statistics -> Waits | |
| Lock Statistics -> Wait Time | |
| Sessions -> Details | |
| User Session | |
| Status | |
| Host | |
| Net Library | |
| Network Address | |
| User | |
| Application | |
| Database | |
| Transaction Isolation Level | |
| Login Time | |
| Last Activity | |
| Physical I/O | |
| CPU (ms) | |
| Memory (kb) | |
| Open Transactions | |
| Wait Time (ms) | |
| Blocking | |
| Blocking Count | |
| Version Store Elapsed Seconds | |
| Space Used in kb (Alloc / Dealloc) | |
| Session User Space | |
| Task User Space | |
| Session Internal Space | |
| Task Internal Space | |
| Overview -> Details | 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 | |
| Database Count | |
| 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 Metrics Availability | |
| 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 | |
| Procedure Cache Hit ratio | |
| 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 Recompilations | |
| Sql Recompilations Per Second | |
| System Processes | |
| System processes Consuming CPU | |
| User Connections Percent | |
| User Processes | |
| User Processes Consuming CPU | |
| WMI Service Status | |
| Workfiles Created | |
| Workfiles Created Per Second | |
| Worktables Created | |
| Worktables Created Per Second |
For monitored SQL Server instances hosted on Microsoft SQL Azure:
| SQL Diagnostic Manager Area | Collected Metrics by Microsoft SQL Azure |
| Sessions -> Summary | Response Time |
| Sessions | |
| Blocked Sessions | |
| Sessions -> Details | Connection |
| User Session | |
| Status | |
| Host | |
| User | |
| Execution Context | |
| Application | |
| Database | |
| Transaction Isolation Level | |
| Usage | |
| Login Time | |
| Last Activity | |
| Physical I/O | |
| CPU (ms) | |
| Memory (kb) | |
| Lock Information | |
| Wait Time (ms) | |
| Resource | |
| Blocking | |
| Blocking Count | |
| Tempdb Usage | |
| Version Store Elapsed Seconds | |
| Space Used in kb (Alloc / Dealloc) | |
| Session User Space | |
| Task User Space | |
| Session Internal Space | |
Task Internal Space |
Unavailable metrics for Amazon RDS and Microsoft SQL Azure in SQL Diagnostic Manager
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 Writes | |
Checkpoint Writes 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 |