Just One Pub Has Very Slow Tracer Latency

  • This is SS 2012. We are using (quite heavily) transactional replication (push). One of the subscribers probably has 30 tables pushed to it from the distributor, which is a completely separate server from the publisher. I just ran a tracer token and it took 44 minutes from the distributor to the sub! What is odd is that all the other publications that push to this subscriber have no issues: they push the token in less than 2 minutes.

    What would cause just one pub to have a horrendous latency to the sub while all the other pubs are fine?

    I can't even conceive what would cause that in order to troubleshoot the issue.

  • Have you checked network in between both servers? Are they on the same SAN? Anything obvious in SQL error logs?

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply