transactional replication slowdown

• lilywhites

  SSCrazy

  Points: 2732

  More actions

  June 14, 2016 at 3:05 am

  #327453

  hello

  a few days ago we had a network issue and caused a pk violation against a couple of replicated tables.

  cleaned out the rows and reset the agents and it started back up.

  however, since then it has been running very slowly. we used to get 100 transactions with 100 commands delivered from the distributor to the subscriber regularly every few seconds....now it struggles to get 10 and 10 every minute.

  we still have no latency between the publisher and distributor.

  i cannot think of any possible reasons....can anyone else?

  thanks

• gfoxxy93

  Right there with Babe

  Points: 776

  More actions

  June 14, 2016 at 5:14 am

  #1884842

  Good article by Brent Ozar that might be of some use to you.

  Here[/url]