Post reply

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

  • February 24, 2010 at 1:53 pm

    #138957

    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

  • February 24, 2010 at 10:14 pm

    #1124750

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

    EnjoY!

    EnjoY!

  • February 25, 2010 at 6:07 am

    #1124897

    I think counter value parameter is in milli seconds.

    Manu

  • February 25, 2010 at 7:10 am

    #1124949

    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