Versions Compared

Key

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

...

Alerts compatible with the alert response bundles feature

Jobs

    • SQL Server Agent Long Running Job (Minutes)
    • SQL Server Agent Long Running Job (Percent)
    • SQL Server Agent Job Completion
    • SQL Server Agent Job Failure
    • SQL Server Agent Log

Blocking and Deadlocks

    • Blocked Sessions
    • Blocked Sessions Wait Time (Seconds)
    • Deadlock

Size Databases

    • Data File Autogrow
    • Database Full (Percent)
    • Database Full (Size)

Size Disks

    • OS Average Disk Queue Length (Count)
    • OS Average Disk Queue Length Per Disk (Count)
    • OS Disk Free Space (Size)
    • OS Disk Full (Percent)
    • OS Disk Time (Percent)
    • OS Disk Time Per Disk (Percent)

Error Log

    • SQL Server Error Log

Availability Group Databases

    • Availability Group Estimated Data Loss (Seconds)
    • Availability Group Estimated Recovery time (Seconds) 
    • Availability Group Log Send Queue Size (KB)
    • Availability Group Preferred Replica
    • Availability Group Redo Queue Size (KB)  
    • Availability Group Redo Rate (KB/sec)
    • Availability Group Role Change
    • Availability Group Synchronization Health
    • Availability Group Synchronization Performance (Seconds)
Scroll pdf ignore
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >