How can we stop the probe alarming when the secondary nodes in the AG are in states 1 and 2 ? i.e. we are only interested in alarms being raised where the state is 0.

Answer:

1/ Deactivate the sqlserver probe2/ Go into the probe Raw Configure, then expand the checkpoints and expand the aag_db_replica_synchronization_state checkpoint.3/ Edit the condition value from != to = and apply. 4/ Go into the probe configuration gui and amend the threshold for the checkpoint to 05/ Once the change has been applied, and probe restarted, the alarm should only be raised for state 0

These are the states for the checkpoint as of the 5.30 version of the sqlserver probe: