Measuring Always On Availability Group potential data loss
I've occassionally created specific tables for this purpose, sometimes called &quot;tracer&quot; or &quot;canary&quot; tables. It has one column which is a datetime. A job runs on the source system inserting the current time. This runs at whatever granularity you need - minutes apart was sufficient for me. Read the max value from the secondary &amp; that's how far behind you are.