network latency error

  • How to slove the network latency errors in transactional replication?

    what tracer tokens are useful to solve ?

  • Tracer tokens are really just for confirming that "yes" latency is poor (or good depending on if things are running smoothly). How large is your set up (i.e. how many articles per publication)? And what's the rate of change on the tables in the publisher?

    You could look at enabling subscription streams (it's been a life-saver for me)

    http://blogs.msdn.com/b/repltalk/archive/2010/03/01/navigating-sql-replication-subscriptionstreams-setting.aspx

    Also, have you checked with your IT department to see if the bandwidth is actually a problem?

    ______________________________________________________________________________Never argue with an idiot; Theyll drag you down to their level and beat you with experience

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

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