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 latency Expand / Collapse
Author
Message
Posted Monday, December 10, 2012 7:16 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Yesterday @ 5:46 AM
Points: 123, Visits: 513
i have 2 servers, which have transactional replication between them,connected physically between them with a cross cable.
the subscriber pull's the data from data.

The thing is that in REPLICATION MONITOR I see the column LATENCY show 52 minutes,

However when I use the Replication Monitor script taken from here:

http://sqlfool.com/tag/monitor/

I get data that overall_latency is no more than 3-4 seconds, distributor_latency 3-4 seconds and subscriber_latency is zero.

The script also checks using INSERT TOKEN where everything is normal, when I do the same test from the REPLICATION MONITOR I get to 50 minutes.

How can i figure out which results are correct, because on the Distributor to subscriber History i see all the transactions and the tables are up to date?
this problem makes monitoring the replication less reliable.

any idea?
Post #1394605
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse