August 13, 2008 at 4:12 am
Has any one successfully setup alerts for transactional replication latency?
I have selected "Warn if latency exceeds the threshold" and threshold = 30 seconds.
I have selected alert "Replication Warning: Transactional replication latency (Threshold: latency)"
Eventhough latency exceeds 30 seconds, it is not working. No email is sent. There is no entry in the application event log.
'Replication: Subscriber has failed data validation' and 'Replication: agent retry' are working.
August 20, 2008 at 5:36 pm
is there an operator setup? is your server setup to send out notification?
I wouldn't rely on those latency BS SQL got, it didn't do me any good in the past. I ended up writing my own replication check.
-----------------------------
www.cbtr.net
.: SQL Backup Admin Tool[/url] :.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply