Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL Server Alert System: 'Replication Warning: Transactional replication latency (Threshold: latency) Expand / Collapse
Author
Message
Posted Wednesday, February 24, 2010 1:53 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 01, 2010 7:44 AM
Points: 176, Visits: 290
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
Post #872271
Posted Wednesday, February 24, 2010 10:14 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Friday, December 20, 2013 9:25 AM
Points: 389, Visits: 357
Yes, it will fire an alert if latency is more than 10 secs. That is what you set up correct?

EnjoY!


EnjoY!
Post #872473
Posted Thursday, February 25, 2010 6:07 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: 2 days ago @ 10:30 PM
Points: 1,688, Visits: 8,759
I think counter value parameter is in milli seconds.

Manu
Post #872648
Posted Thursday, February 25, 2010 7:10 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, September 01, 2010 7:44 AM
Points: 176, Visits: 290
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
Post #872703
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse