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

Replication Monitor read outs Expand / Collapse
Author
Message
Posted Sunday, January 26, 2014 12:59 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 10:41 AM
Points: 29, Visits: 114
I have a transaction replication environment using a three publishers, one distributor, and one subscriber. Everything seems to be running fine. However, I don't quite understand how to read the replication monitor. It seems straightforward but, at times, a subscriber can have 'critical performance' and a very high latency (30 minutes for example). However, if I insert a tracer token, the total latency is only 8-9 seconds, which leads me to believe transactions are getting to the subscriber in 8-9 seconds, not 30 minutes. So which one should I believe? Should I be worried a subscriber is in 'critical performance'?
Post #1534771
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse