Submitting forms on the support site are temporary unavailable for schedule maintenance. If you need immediate assistance please contact technical support. We apologize for the inconvenience.
How does the "DBSS - Availability Group Database is not Failover Ready" rule work?
설명
How does the DBSS - Availability Group Database is not Failover Ready rule determine when to fire an alarm?
해결 방안
The rule looks at the SQL Server availability groups and replicas and then determines whether to fire the alarm based on the following conditions from the collected metrics.
A). The rule will first check if either of two conditions are true If availability_mode = 1 AND #is_failover_ready# = 0 OR IF #estimated_data_loss# > 5 AND #is_failover_ready# = 0 -- Then condition A is TRUE
B). Then the rule will check if database_role_desc is not null AND database_role_desc = SECONDARY AND #is_local# = 1 -- Then condition B is TRUE
IF condition A is TRUE and condition B is TRUE then do not fire the alarm. IF condition A is FALSE then do not fire the alarm. IF condition A is TRUE and condition B is FALSE then fire the alarm.
