replication latency

• peleg

  SSCrazy

  Points: 2611

  More actions

  December 10, 2012 at 7:16 am

  #271403

  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?