SQL Server Alert System: 'Replication Warning: Transactional replication latency (Threshold: latency)

  • Hi,

    Can someone please help me to set up the parameters of Transactional replication latency

    SQL Server Alert System: 'Replication Warning: Transactional replication latency (Threshold: latency)

    I set up the Threshold into 10 Sec, And configration Alter if counter value >10.

    But I am getting an email every 10 min and regardless the latency Threshold values its say “'SQLServer:Replication Logreader' is now above the threshold of 10.00 (the current value is 1000.00).

    Thanks for your help in advance

  • Yes, it will fire an alert if latency is more than 10 secs. That is what you set up correct?

    EnjoY!

    EnjoY!
  • I think counter value parameter is in milli seconds.

    Manu

  • Thanks for help,

    But when Iset Alter if counter value >10, I am getting an email every 10 minutes

    I wants email only when LATENCY Threshold is more then 10 Secound

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply