Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Replication Monitor read outs Expand / Collapse
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: Wednesday, August 5, 2015 12:16 PM
Points: 32, Visits: 215
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