Skip to main content
assistive.skiplink.to.breadcrumbs
assistive.skiplink.to.header.menu
assistive.skiplink.to.action.menu
assistive.skiplink.to.quick.search
Log in
Help / Tips
Help
Online Help
Keyboard Shortcuts
Feed Builder
What’s new
Available Gadgets
About Confluence
Search
Quick Search
Hit enter to search
SQL Diagnostic Manager 12.3
Content
Pages
Blog
Space Tools
Settings
Content Tools
View Page
A
t
tachments (0)
Page History
Navigation View
Page Information
View in Hierarchy
View Source
Export to PDF
Export to Word
Export to PDF
Page Information
Title:
Metric alerts
Author:
Nadja Pollard
Jan 27, 2025
Last Changed by:
Nadja Pollard
Jan 27, 2025
Tiny Link:
(useful for email)
https://wiki.idera.com/x/Wg0S_QI
Export As:
Word
·
PDF
Incoming Links
SQL Diagnostic Manager 12.3 (2)
Page:
Monitor AlwaysOn Availability Groups
Page:
Instances hosted on the cloud
Hierarchy
Parent Page
Home page:
SQL Diagnostic Manager for SQL Server
Children (132)
Page:
Availability Group Estimated Data Loss (Seconds) alert
Page:
Availability Group Estimated Recovery time (Seconds) alert
Page:
Availability Group Log Send Queue Size (KB) alert
Page:
Availability Group Preferred Replica alert
Page:
Availability Group Redo Queue Size (KB) alert
Page:
Availability Group Redo Rate (KB\sec) alert
Page:
Availability Group Role Change alert
Page:
Availability Group Synchronization Health alert
Page:
Availability Group Synchronization Performance (Seconds) alert
Page:
Average Data IO Percent High
Show all...
Page:
Average Data IO Percent Low
Page:
Average Disk Milliseconds Per Read alert
Page:
Average Disk Milliseconds Per Transfer alert
Page:
Average Disk Milliseconds Per Write alert
Page:
Average Log Write Percent High
Page:
Average Log Write Percent Low
Page:
Blocked Sessions (Count) alert
Page:
Blocking Session Wait Time (Seconds) alert
Page:
Client Computers (Count) alert
Page:
CLR Enabled alert
Page:
Cluster Active Node alert
Page:
Cluster Failover alert
Page:
CPU Credit Balance
Page:
CPU Credit Balance Low
Page:
CPU Credit Usage
Page:
Database Average Memory Usage Percent High
Page:
Database Average Memory Usage Percent Low
Page:
Database Full (Percent) alert
Page:
Database Full (Size) alert
Page:
Database Read/Write Error Occurred alert
Page:
Database Status alert
Page:
Data File Autogrow alert
Page:
Days since last backup alerts
Page:
Deadlock alert
Page:
Disk Queue Depth
Page:
Disk Reads Per Second alert
Page:
Disk Transfers Per Second alert
Page:
Disk Writes Per Second alert
Page:
Distribution Latency (Seconds) alert
Page:
DTC Status alert
Page:
Filegroup Space Full (Percent) alert
Page:
Filegroup Space Full (Size) alert
Page:
Full-Text Search Status alert
Page:
Host CPU Usage (Percent) alert
Page:
Host Memory Swap Detected alert
Page:
Host Memory Usage (Percent) alert
Page:
Host Power State alert
Page:
Index Row Hits (Percent) alert
Page:
In-Memory Storage Usage Percent High
Page:
In-Memory Storage Usage Percent Low
Page:
Last Full-Text Catalog Update (Hours) alert
Page:
Latent replication transaction (Count)
Page:
Log File Autogrow alert
Page:
Log Full (Percent) alert
Page:
Log Full (Size) alert
Page:
Longest Running Version Store Transaction (Minutes) alert
Page:
Maintenance Mode Enabled alert
Page:
Max Session Percent High
Page:
Max Session Percent Low
Page:
Max Worker Percent High
Page:
Max Worker Percent Low
Page:
Mirror Commit Overhead (Milliseconds) alert
Page:
Mirrored Server Role Change alert
Page:
Mirroring Oldest Unsent Transactions (Minutes) alert
Page:
Mirroring Preferred Configuration alert
Page:
Mirroring Status alert
Page:
Mirroring Unrestored Log (KB) alert
Page:
Mirroring Unsent Log (KB) alert
Page:
Mirroring Witness Connection alert
Page:
Oldest Open Transaction (Minutes) alert
Page:
OLE Automation Disabled alert
Page:
OS Average Disk Queue Length (Count) alert
Page:
OS Average Disk Queue Length Per Disk (Count) alert
Page:
OS Disk Free Space (Size) alert
Page:
OS Disk Full (Percent) alert
Page:
OS Disk Time (Percent) alert
Page:
OS Disk Time Per Disk (Percent) alert
Page:
OS Memory Usage (Percent) alert
Page:
OS Metrics Collection Status alert
Page:
OS Paging (Per Second) alert
Page:
OS Privileged Time (Percent) alert
Page:
OS Processor Queue Length (Count) alert
Page:
OS Processor Time (Percent) alert
Page:
OS User Time (Percent) alert
Page:
Page Life Expectancy alert
Page:
Procedure Cache Hit Ratio (Percent) alert
Page:
Query Monitor Events (Count) alert
Page:
Read Latency High
Page:
Read Latency Low
Page:
Read Throughput
Page:
Service Tier Changes
Page:
Session CPU Time (Seconds) alert
Page:
Session Tempdb Space Usage (MB) alert
Page:
SQLdm Repository Grooming Timed Out alert
Page:
SQLDM Service Status alert
Page:
SQL Server Active Directory Helper Service Status alert
Page:
SQL Server Agent Job Completion alert
Page:
SQL Server Agent Job Failure alert
Page:
SQL Server Agent Log alert
Page:
SQL Server Agent Long Running Job (Minutes) alert
Page:
SQL Server Agent Long Running Job (Percent) alert
Page:
SQL Server Agent Status alert
Page:
SQL Server Agent XPs Disabled alert
Page:
SQL Server Browser Service Status alert
Page:
SQL Server CPU Usage (Percent) alert
Page:
SQL Server Data Used (Percent) alert
Page:
SQL Server Error Log alert
Page:
SQL Server Log Used (Percent) alert
Page:
SQL Server Memory Usage (Percent) alert
Page:
SQL Server Response Time (Milliseconds) alert
Page:
SQL Server Service
Page:
Swap Usage
Page:
Table Fragmentation (Percent) alert
Page:
Tempdb Contention (ms) alert
Page:
Unsubscribed Transactions (Count) alert
Page:
Unsubscribed Transactions (Seconds) alert
Page:
User Connections (Percent) alert
Page:
Version Store Generation Ratio alert
Page:
Version Store Size (MB) alert
Page:
VM CPU Ready Wait Time (ms) alert
Page:
VM CPU Usage (Percent) alert
Page:
VM Host Server Change alert
Page:
VM Memory Swap Delay Detected alert
Page:
VM Memory Usage (Percent) alert
Page:
VM Power State alert
Page:
VM Reclaimed/Ballooned Memory (KB) alert
Page:
VM Resource Configuration Change alert
Page:
VM Resource Limits Detected alert
Page:
WMI Service Unavailable alert
Page:
Write Latency High
Page:
Write Latency Low
Page:
Write Throughput
Hide...
Labels
Global Labels (2)
dm
metrics
Recent Changes
Time
Editor
Jan 27, 2025 19:08
Nadja Pollard
View Page History
Outgoing Links
External Links (22)
wiki.idera.com/display/SQLDM/Database+Average+Memory+Usage+…
wiki.idera.com/display/SQLDM/Read+Throughput
community.idera.com
wiki.idera.com/display/SQLDM/CPU+Credit+Usage
wiki.idera.com/display/SQLDM/Write+Latency+Low
wiki.idera.com/display/SQLDM/Average+Log+Write+Percent+Low
wiki.idera.com/display/SQLDM/Service+Tier+Changes
wiki.idera.com/x/hgE1
wiki.idera.com/display/SQLDM/Write+Throughput
wiki.idera.com/display/SQLDM/Read+Latency+High
wiki.idera.com/display/SQLDM/Read+Latency+Low
wiki.idera.com/display/SQLDM/Write+Latency+High
wiki.idera.com/display/SQLDM/Swap+Usage
wiki.idera.com/display/SQLDM/CPU+Credit+Balance+Low
wiki.idera.com/display/SQLDM/Average+Log+Write+Percent+High
wiki.idera.com/display/SQLDM/Max+Session+Percent+High
wiki.idera.com/display/SQLDM/In-Memory+Storage+Usage+Percen…
www.idera.com/resourcecentral
https://wiki.idera.com/x/Avg3kg
www.idera.com/productssolutions/sqlserver
wiki.idera.com/display/SQLDM/Average+Data+IO+Percent+High
wiki.idera.com/display/SQLDM/Disk+Queue+Depth
SQL Diagnostic Manager 12.3 (107)
Page:
Availability Group Estimated Data Loss (Seconds) alert
Page:
Longest Running Version Store Transaction (Minutes) alert
Page:
Latent replication transaction (Count)
Page:
Page Writes (Per Second)
Page:
SQL Server Log Used (Percent) alert
Page:
Distribution Latency (Seconds) alert
Page:
Availability Group Log Send Queue Size (KB) alert
Page:
VM Power State alert
Page:
WMI Service Unavailable alert
Page:
Average Data IO Percent Low
Page:
SQLdm Repository Grooming Timed Out alert
Page:
Disk Writes Per Second alert
Page:
Max Session Percent Low
Page:
SQL Server Agent Job Completion alert
Page:
Availability Group Redo Rate (KB\sec) alert
Page:
Disk Transfers Per Second alert
Page:
Mirroring Unsent Log (KB) alert
Page:
SQL Server Agent Long Running Job (Percent) alert
Page:
User Connections (Percent) alert
Page:
Database Full (Percent) alert
Page:
OS Disk Time Per Disk (Percent) alert
Page:
Log Full (Size) alert
Page:
CLR Enabled alert
Page:
VM CPU Usage (Percent) alert
Page:
Deadlock alert
Page:
OS Disk Free Space (Size) alert
Page:
Mirroring Oldest Unsent Transactions (Minutes) alert
Page:
In-Memory Storage Usage Percent Low
Page:
Availability Group Synchronization Health alert
Page:
SQL Server Response Time (Milliseconds) alert
Page:
SQL Server Data Used (Percent) alert
Page:
Database Full (Size) alert
Page:
Max Worker Percent Low
Page:
Mirroring Unrestored Log (KB) alert
Page:
Cluster Failover alert
Page:
SQL Server Agent Long Running Job (Minutes) alert
Page:
VM CPU Ready Wait Time (ms) alert
Page:
Average Disk Milliseconds Per Read alert
Page:
SQL Server Agent Status alert
Page:
Availability Group Role Change alert
Page:
Database Average Memory Usage Percent Low
Page:
Host Memory Usage (Percent) alert
Page:
Max Worker Percent High
Page:
DTC Status alert
Page:
OS Average Disk Queue Length Per Disk (Count) alert
Page:
Version Store Size (MB) alert
Page:
VM Resource Limits Detected alert
Page:
Log Full (Percent) alert
Page:
Data File Autogrow alert
Page:
Oldest Open Transaction (Minutes) alert
Page:
Cluster Active Node alert
Page:
Mirroring Status alert
Page:
Last Full-Text Catalog Update (Hours) alert
Page:
OS Average Disk Queue Length (Count) alert
Page:
Unsubscribed Transactions (Seconds) alert
Page:
OS User Time (Percent) alert
Page:
Disk Reads Per Second alert
Page:
OS Memory Usage (Percent) alert
Page:
VM Resource Configuration Change alert
Page:
Blocking Session Wait Time (Seconds) alert
Page:
SQL Server Browser Service Status alert
Page:
Host Power State alert
Page:
Availability Group Estimated Recovery time (Seconds) alert
Page:
Version Store Generation Ratio alert
Page:
Availability Group Synchronization Performance (Seconds) alert
Page:
SQL Server Agent Log alert
Page:
OS Disk Full (Percent) alert
Page:
Procedure Cache Hit Ratio (Percent) alert
Page:
Days since last backup alerts
Page:
Client Computers (Count) alert
Page:
Session CPU Time (Seconds) alert
Page:
Table Fragmentation (Percent) alert
Page:
VM Memory Usage (Percent) alert
Page:
SQL Server Active Directory Helper Service Status alert
Page:
Host CPU Usage (Percent) alert
Page:
VM Host Server Change alert
Page:
Page Life Expectancy alert
Page:
Availability Group Redo Queue Size (KB) alert
Page:
Average Disk Milliseconds Per Transfer alert
Page:
Filegroup Space Full (Size) alert
Page:
Blocked Sessions (Count) alert
Page:
OLE Automation Disabled alert
Page:
Database Status
Page:
OS Disk Time (Percent) alert
Page:
VM Memory Swap Delay Detected alert
Page:
OS Metrics Collection Status alert
Page:
Tempdb Contention (ms) alert
Page:
SQL Server Error Log alert
Page:
Log File Autogrow alert
Page:
Host Memory Swap Detected alert
Page:
Availability Group Preferred Replica alert
Page:
Mirrored Server Role Change alert
Page:
OS Privileged Time (Percent) alert
Page:
Full-Text Search Status alert
Page:
Query Monitor Events (Count) alert
Page:
SQL Server Memory Usage (Percent) alert
Page:
SQL Server Agent XPs Disabled alert
Page:
Filegroup Space Full (Percent) alert
Page:
OS Processor Queue Length (Count) alert
Page:
Mirroring Preferred Configuration alert
Page:
OS Processor Time (Percent) alert
Page:
Mirroring Witness Connection alert
Page:
Unsubscribed Transactions (Count) alert
Page:
Index Row Hits (Percent) alert
Page:
SQL Server CPU Usage (Percent)
Page:
Average Disk Milliseconds Per Write alert
Page:
Session Tempdb Space Usage (MB) alert
SQL Diagnostic Manager 11.0 (1)
Page:
Mirror Commit Overhead (Milliseconds) alert
null