Comments
-
Sure madisonpaul! I guess we had slightly different goals, we're AG for redundancy not for load, and so are agnostic about what node is active as long as the group is synchronized. Just my .02, but I would probably hard code the expected results of the query in the monitor rather than a results table. I use the "Notify…
-
Here's the one I just made. Looks to test out OK. select count(*) from sys.dm_hadr_availability_group_states where synchronization_health != 2