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.
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:
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.