Alert monitoring AG replication lag/delay/estimated data loss

jsql

Hello, 

We recently had an issue with an asynchronous AG replica that was far behind in replication.  See attached.

Is there a way to set up an alert that would fire if the estimated data loss exceeds a certain threshold?

I don't find anything obvious at the moment in DPA.

Thanks!

AG_PROBLEM.png

mandevil

I added a custom alert out there for just this use case: Custom Alert - AG Data Loss Alert

See if that does what you want or perhaps even customize it to your needs.

HTH!