Page History
...
For monitored SQL Server instances hosted on Amazon RDS
SQL Diagnostic Manager Area | Collected Metrics by Amazon RDS |
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 |
Seconds |
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 | |
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 | |
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 |
For monitored SQL Server instances hosted on Microsoft SQL Azure
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 |
AnchorMU MU
Unavailable metrics for Amazon RDS and Microsoft SQL Azure in SQL Diagnostic Manager
MU | |
MU |
...
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 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
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 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 |
Sessions → Summary | Lock Statistics → Average Wait Time |
Lock Statistics → Deadlocks | |
Lock Statitstics → Requests | |
Lock Statistics → Timeouts | |
Lock Statistics → Waits | |
Lock Statistics → Wait Time | |
Sessions |
→ Details |
Connection |
---|
Net library |
Network Address |
Usage |
Open |
Transaction |
Lock Information |
---|
Wait |
Type |
...