Version 1

    DESCRIPTION

    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