Custom Alert - AG Data Loss Alert

This alert will query data already collected by DPA to be used in a custom alert. It will trigger based on thresholds you establish for estimated data loss due to latent AG replication.


To create this alert, click on Alerts > Manage Alerts tab and create a Custom Alert of type Custom SQL Alert - Single Numeric Return making it look similar to this example.

Alert Name: AG Data Loss Alert

Execution Interval: 4 Minutes

Notification Text: Potential data loss if forced failover occurs

Available Instances: <choose any SQL instances>

SQL Statement:

select est_data_loss from con_ag_database

Execute Against: Repository

Units: Seconds

High Threshold: User Defined

Warning Threshold: User Defined