cancel
Showing results for 
Search instead for 
Did you mean: 
Create Post
Highlighted
Level 11

SQL ALWAYSON HIGH AVAILABILITY " NOT SYNCHRONIZATION/CRITICAL

0 Kudos
3 Replies
Highlighted
Product Manager
Product Manager

Re: SQL ALWAYSON HIGH AVAILABILITY " NOT SYNCHRONIZATION/CRITICAL

if you have DPA, it can monitor and alert on Availability Groups for both failover and status change.

See this article for more information on AG functionality and alerts in DPA: https://support.solarwinds.com/Success_Center/Database_Performance_Analyzer_(DPA)/DPA_111_feature_Im...

Highlighted
Level 8

Re: SQL ALWAYSON HIGH AVAILABILITY " NOT SYNCHRONIZATION/CRITICAL

We've instituted the above alert for our AG and it worked like a charm.  We were  notified when the PRIMARY NODE's lease expired and failed over to the 2ndary - we were able to then react to this issue before anyone knew that an issue had occurred.  I would recommend setting the check intervals to 1 minute though as a 5 minute window or greater could be spell disaster.

Highlighted
Level 11

Re: SQL ALWAYSON HIGH AVAILABILITY " NOT SYNCHRONIZATION/CRITICAL

Hi, Thanks yes, I have fixed it by DPA 11.1.

0 Kudos