Version 1


    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