SQL Diagnostic Manager allows you to view a wide range of information collected for your PaaS monitored instances hosted on Amazon RDS and Microsoft SQL Azure (Azure SQL Database, elastic pool and managed instances).

In addition, SQLDM supports monitoring of images hosted on virtualized or cloud IaaS environments such as SQL Server on Azure virtual machines and Amazon EC2. Monitoring a virtualized instance requires no cloud-specific configuration.

 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

For monitored SQL Server instances hosted on Amazon RDS

SQL Diagnostic Manager AreaCollected Metrics by Amazon RDS
Overview → DetailsBatches
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 → SummaryResponse 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 AreaCollected Metrics by Microsoft SQL Azure
Overview→ DetailsResponse Time
Sessions → SummaryResponse 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

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 areaInformation 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 areaInformation 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
IDERA ProductsPurchase | Support | Community | Resources | About Us | Legal