| SQL Diagnostic Manager Area | Collected Metrics by Amazon RDS
|
|
|
| Sessions -> 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 -> Sessions → Details |
| Connection |
|---|
| User Session |
| Status |
| Host |
| Net Library |
| Network Address |
| User |
| Application |
| Database |
| Transaction Isolation Level |
| Usage |
|---|
| Login Time |
| Last Activity |
| Physical I/O |
| CPU (ms) |
| Memory (kb) |
| Open Transactions |
| Lock Information |
|---|
| Wait Time (ms) |
| 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 |
| Last Command |
|---|
| Overview -> Overview → Details | 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 |
| 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 |
| 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 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 |