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.
ALERT DEFINITION
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
