You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 27 Next »

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).

When monitoring Amazon RDS servers, SQL Diagnostic Manager cannot monitor or alert on SQL Agent jobs.

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.

SQL Diagnostic Manager has new DBaaS metrics and alerts, for more information review the Metric Alerts.

 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 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



IDERA ProductsPurchase | Support | Community | Resources | About Us | Legal


  • No labels