Page History

Versions Compared

Key

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

SQL Diagnostic Manager offers numerous alerts to successfully monitor and warn you about your SQL Server instances and availability groups. Proper configuration is key to making sure you receive alerts only on those metrics that actually fall outside the typical performance of your environment. SQL Diagnostic Manager includes the following metric alerts for your use:

Info
The alerts are listed by default Ranks and categories. The default Ranks are classified as follows: Rank 10 = Service High Rank 20 = Resource High Rank 30 = Database High Rank 40 = Process High Rank 50 = Service Low Rank 60 = Resource Low Rank 70 = Database Low Rank 80 = Process Low Rank 90 =Other

Info

The alerts are listed by default Ranks and categories. The default Ranks are classified as follows:

Rank 10 = Service High
Rank 20 = Resource High
Rank 30 = Database High
Rank 40 = Process High
Rank 50 = Service Low
Rank 60 = Resource Low
Rank 70 = Database Low
Rank 80 = Process Low
Rank 90 =Other

Category: Backup

Metric	Rank
Days since last backup	40

Category: Databases

Metric	Rank
Availability Group Estimated Data Loss (Seconds)	20
Availability Group Estimated Recovery time (Seconds)

...

	20
Availability Group Log Send Queue Size (KB)	20
Availability Group Preferred Replica

...

	10
Availability Group Redo Queue Size (KB)

...

	20
Availability Group Redo Rate (KB/sec)	20
Availability Group Role Change	10
Availability Group Synchronization Health	20
Availability Group Synchronization Performance (Seconds)

...

20
Data File Autogrow	70
Database Full (Percent)	30
Database Full (Size)	30
Database Read/Write Error Occurred	30
Database Status

...

30
Filegroup Space Full (Percent)	30
Filegroup Space Full (Size)

...

Index Row Hits (Percent)

...

70
Log File Autogrow	70
Log Full (Percent)	30
Log Full (Size)	30
Longest Running Version Store Transaction (Minutes)	30
Mirror Commit Overhead (Milliseconds)	30
Mirrored Server Role Change	30
Mirroring Oldest Unsent Transactions	30
Mirroring Preferred Configuration	30
Mirroring Status	30
Mirroring Unrestored Log (KB)	30
Mirroring Unsent Log (KB)	30
Mirroring Witness Connection

...

	30
Session Tempdb Space Usage (MB)	80
Table Fragmentation (Percent)	70
Tempdb Contention (ms)	20
Version Store Generation Ratio	30
Version Store Size (MB)	30

Category: DBaaS

Metric	Rank
Average Data IO Percent	100
Average Log Write Percent	100
CPU Credit balance	100
CPU Credit Usage	100
Database Average Memory Usage Percent	100
Disk Queue Depth	100
In-Memory Storage Usage Percent	100
Max Session Percent	100
Max Worker Percent	100
Read Latency	100
Read Throughput	100
Service Tier Changes	100
Swap Usage	100
Write Latency	100
Write Throughput	100

Category: Logs

Metric	Rank
SQL Server Agent Log	40
SQL Server Error Log	40

Category: Operational

Metric	Rank
CLR Enabled	90
OLE Automation Disabled	90
OS Metrics Collection Status	90
SQL Server Agent XPs Disabled	50
SQL Server Data Used (Percent)	30
SQL Server Log Used (Percent)	30
SQLdm Repository Grooming Timed Out	90
WMI Service Unavailable	50

Category: Queries

Metric	Rank
Query Monitor Events (Counts)	80

Category: Resources

Metric	Rank
Average Disk Milliseconds Per Read	20
Average Disk Milliseconds Per Transfer	20
Average Disk Milliseconds Per Write	20
Disk Reads Per Second	60
Disk Transfers Per Second	60
Disk Writes Per Second	60
OS Average Disk

...

Queue Length (Count)	20
OS Average Disk Queue Length Per Disk (Count)	60
OS Disk Free Space (Size)	20
OS Disk Full (Percent)	20
OS Disk Time (Percent)	60
OS Disk Time Per Disk (Percent)	60
OS Memory Usage (Percent)

...

20
OS Paging (Per Second)	60
OS Privileged Time (Percent)	60
OS Processor Queue Length (Count)	20
OS Processor Time (Percent)	20
OS User Time (Percent)	60
Page Life Expectancy	60
Procedure Cache Hit Ratio

...

	20
SQL Server CPU Usage (Percent)	20
SQL Server Memory Usage (Percent)	20

Category: Services

Metric	Rank
Cluster Active Node	10
Cluster Failover	10
Distribution Latency (Seconds)	40
DTC Status	10
Full-Text Search Status	50
Last Full-Text Catalog Update (Hours)	50
Latent replication transaction (Count)	40
SQL Server Active Directory Helper Service Status	50
SQL Server Agent Job Completion	80
SQL Server Agent Job Failure

...

40
SQL Server Agent Long Running Job (Minutes)	80
SQL Server Agent Long Running Job (Percent)	80
SQL Server Agent Status

...

10
SQL Server Browser Service Status	50
SQL Server

...

Status	10
Unsubscribed Transactions (Count)	40
Unsubscribed Transactions (Seconds)	80

Category: Sessions

Metric	Rank
Blocked Sessions	40
Blocked Sessions Wait Time (Seconds)	40
Client Computers	60
Deadlock	80
Oldest Open Transaction (Minutes)	40
Session CPU Time (Seconds)	80

...

SQL Server Response Time (Milliseconds)

...

User Connections

...

(Percent)

...

Category: Virtualization

Metric	Rank
Host CPU Usage (Percent)	20
Host Memory Swap Detected	20
Host Memory Usage (Percent)	20
Host Power State	20

...


VM CPU Ready Wait Time (ms)	20
VM CPU Usage (Percent)	20
VM Host Server Change	20
VM Memory Swap Delay Detected	20
VM Memory Usage (Percent)	20
VM Power State	20
VM Reclaimed/Ballooned Memory (KB)	20
VM Resource Configuration Change	20
VM Resource Limits Detected

...

Scroll pdf ignore

SQL Diagnostic Manager for SQL Server performance monitoring, alerting, and diagnostics for SQL Server.

Newtabfooter
alias IDERA
url http://www.idera.com
|
Newtabfooter
alias Products
url https://www.idera.com/productssolutions/sqlserver
|
Newtabfooter
alias Purchase
url https://www.idera.com/buynow/onlinestore
|
Newtabfooter
alias Support
url https://idera.secure.force.com/
|
Newtabfooter
alias Community
url http://community.idera.com
|
Newtabfooter
alias Resources
url http://www.idera.com/resourcecentral
|
Newtabfooter
alias About Us
url http://www.idera.com/about/aboutus
|
Newtabfooter
alias Legal
url https://www.idera.com/legal/termsofuse

Content

Space Tools