Page History
...
- 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.
...
| SQL Diagnostic Manager Area | Collected Metrics by Microsoft SQL Azure |
| Overview→ Details | Response Time |
| 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 | |
| Last Command |
Anchor MU MU
Unavailable metrics for Amazon RDS
| MU | |
| MU |
...
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:
...
| 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 CPU Activity | |
Sql Memory Used Percent | |
Used Memory (Percent) | |
| Sessions → Details | |
| Connection | |
| Execution Context | |
| Usage | |
| Lock Information | |
| Lock Information | |
| Wait Type | |
| Resource |
For monitored SQL Server instances hosted on Microsoft SQL Azure
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 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
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
Lock Statistics → Average Wait Time
Lock Statistics → Deadlocks
Lock Statistics → Requests
Lock Statistics → Timeouts
Lock Statistics → Waits
Lock Statistics → Wait Time
Net library
...