Restituisci
-
Titolo
What rules are available for SQL Server availability groups -
Descrizione
What rules are available for SQL Server availability groups?
-
Risoluzione
Current Rules
The following availability group rules are present in the SQL Server cartridge.
- DBSS - Availability Group Database is not Failover Ready - This alarm is invoked when the database is not marked as synchronized in the cluster, and is therefore not ready for a planned manual failover. As a result, forcing failover to the host secondary replica will result in a data loss on this database.
- DBSS - Availability Group Database is Not Synchronizing - This alarm is invoked when the data synchronization state is NOT SYNCHRONIZING, or if the state is not SYNCHRONIZED for the synchronous-commit group database.
- DBSS - Availability Group Listener IP is Not Online - This alarm is invoked when the availability group listener IP is offline, either because it is being brought online or because it failed to be brought online.
- DBSS - Availability Group performed a failover - This alarm is invoked when the availability group was over to one of its secondary replicas.
- DBSS - Availability Group Replica is Disconnected - This alarm is invoked when the availability group replica is disconnected, and is therefore not ready for a failover.
- DBSS - Availability Replica is Not Online - This alarm is invoked when the availability replica is unable to read or write from the cluster
- DBSS - Availability Replica is Not Synchronizing - This alarm is invoked when the data synchronization state is NOT SYNCHRONIZING, or if the state is not SYNCHRONIZED for the synchronous-commit database replica.
Introduced in SQL Server cartridge version 6.3.0.10
- DBSS - Availability Group potential data loss baseline deviation - This alarm is raised when the availability group potential data loss (RPO) baseline deviation is detected. The situation may indicate that availability group databases are no synchronizing properly and potential data log during failover is not meeting the organization SLA (service-level agreement) (Average Estimated Data Loss). This was logged as FOG-4986.
- DBSS - Availability Group estimated time for failover baseline deviation - This alarm is raised when availability group estimated time for failover (RTO) baseline is detected. This situation may indicate that availability group databases are not synchronizing properly and time to failover is not meeting organization SLA (service-level agreement). This was logged as FOG-4987.
Considered for a future release
The following enhancement requests are currently under consideration:
- FOG-8944 - Rule for Availability Group estimated time for failover (RTO) above a threshold
- FOG-8945 - Rule for Availability Group potential data loss (RPO) above a threshold.
-
ID difetto
FOG-8944 -
Informazioni aggiuntive
FOG-8946 is an additional enhancement in the HADR dashboard to display Average Estimated Data Loss and Average Estimated Recovery Time history.
This enhancement along with FOG-8944 and FOG-8945 are intended to help the user get a clearer picture of the state of the availability groups.