Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

Warning

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

Note

In addition, SQLDM supports monitoring images with SQL Server installed

Note
SQL DM 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:

(e.g., Azure virtual machines, Amazon EC2, or Google Compute Engine). Monitoring a virtualized instance requires no cloud-specific configuration.

Tip

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

For more information on metrics, check the Metric Alerts page. Below is some information about the additional metrics data available for cloud instances. 

Info

For more information on

...

Amazon RDS and Microsoft SQL Azure

...

user permission, visit the User Creation Scripts page.

 
Anchor
MA
MA

...

Additional metrics for Amazon RDS and Microsoft SQL Azure in SQL Diagnostic Manager

For monitored SQL Server instances hosted

...

on Amazon RDS

...

:

  • CPU Credit Balance High

  • CPU Credit Balance Low

  • CPU Credit Usage

  • Disk Queue Depth

  • Read Latency High

  • Read Latency Low

  • Read Throughput

  • Swap Usage

  • Write Latency High

  • Write Latency Low

  • Write Throughput

For monitored SQL Server instances hosted on Microsoft SQL Azure

...

Task Internal Space

...

:

  • Average Data IO Percent High

  • Average Data IO Percent Low

  • Average Log Write Percent High

  • Average Log Write Percent Low

  • Database Average Memory Usage Percent High

  • Database Average Memory Usage Percent Low

  • In-Memory Storage Usage Percent High

  • In-Memory Storage Usage Percent Low

  • Max Session Percent High

  • Max Session Percent Low

  • Max Worker Percent High

  • Max Worker Percent Low

  • Service Tier Changes


Scroll pdf ignore
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse

...

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 Memory Used Percent

Used Memory(Percent)

Sessions > DetailsBlocked by
Execution Context
Resource
Wait type

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

...

Response Time

...

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

...

Average Wait Time

...

Deadlocks

...

Requests

...

Timeouts

...

Waits

...

Wait Time

...

Blocked by

...

Net library

...

Legal
Scroll pdf ignore
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
IDERA WebsiteProductsPurchaseSupportCommunityAbout UsResources