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