Add alerting for replication performance
Include an alert to monitor replication performance. i.e based on the latency reading that you can view in Replication Monitor. The counters for this are "SQL Server Replication LogReader: Delivery Latency" and "SQL Server Replication Dist.: Delivery Latency". I'd like to be able to set the alert priority based on this.
John Drinkwater
shared this idea
Thanks for the votes and comments on this one. We're actively considering adding replication latency monitoring and alerting to Redgate Monitor.
Since this suggestion was raised, we've added a replication page under Estate tab that lists replication agent jobs with their publisher, distributor, subscriber, publication and job status. It doesn't yet show latency or let you alert on it, but it is something we are considering.
Latency is one of several pieces of replication information customers have asked us for and so it woudl be good to know which of these matter to you:
- Publisher to distributor latency (Log Reader agent delivery latency)
- Distributor to subscriber latency (Distribution agent delivery latency)
- Number of undistributed commands waiting to be applied to each subscriber
- The most recent replication error text for an agent
- + Alerts on any of the above
Please add a comment saying which of these you'd use!
-
Hi John and Nicolaas,
As you may be aware that SQL Monitor now has custom metric and alerts feature. I was just wondering if you have tried writing queries for replication.
If so, would you mind sharing it with us also. You can share your query via this link:
http://sqlmonitormetrics.red-gate.com/share-a-metric/
Thanks,
Priya -
Yes, thats the idea. SQL Monitor shows lots of performance counter. We may allow alerting on those .. though it is still being discussed.
-
Nicolaas Botes
commented
That is excellent news Priya! I think this "custom alert" feature should definitely allow one to create the alert based on the output of a T-SQL script, rather than link it to a performance counter object. This allows more flexibility in the sense that you can either query the sys.dm_os_performance_counters or even the underlying replication system tables.
-
Thanks John .. for your feedback. For V 3.0, we are currently working on custom alert feature. This feature should allow you to write alerts for replication performance counters.