Page History
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.
Note |
---|
SQLDM supports monitoring of images hosted on virtualized or cloud IaaS environments such as Microsoft Azure and Amazon EC2. |
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.
AnchorMA MA
Available metrics for Amazon RDS and Microsoft SQL Azure in SQL Diagnostic Manager
MA | |
MA |
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 |
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 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 |