The Availability Group Estimated Data Loss (Seconds) alert tracks the time period in seconds that data is not synchronized to the secondary replica. This value reflects the time difference of the last commit between the primary and secondary replicas. Alert includes affected databases.

For more information on configuring alerts and setting thresholds, see Configure alerts .

Enable baseline thresholds

To enable alerting when this metric is outside its established baseline, click the Baseline Thresholds Enabled (as percentage of baseline) check box in the Alert Configuration window.

Create an alert response bundle

Create an alert response bundle with the Availability Group Estimated Data Loss (Seconds) alert and related alerts.  For additional information, see Create alert response bundles.

SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >