Replication - one subscriber up to date, the other hours behind

• steve.roberts_boohoo

  SSChasing Mays

  Points: 646

  More actions

  December 4, 2015 at 7:41 am

  #322729

  Hi have a server acting as publisher/distrubutor.

  One subscriber ( actually hosted in AWS and low spec ) is up to date no problems

  Another subscriber ( actually hosted in same building as publisher and very high spec is well behind )

  I've ran profiler against both servers and looked at execution time of various sp_ins and sp_upd routines and both seem to execute straight away so can't understand why the second server is so behind?

• happycat59

  One Orange Chip

  Points: 29384

  More actions

  December 7, 2015 at 8:19 pm

  #1844534

  Check the definition of the Distibution agent for each of the subscribers - perhaps one is continuous and the other is based on a schedule