Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ranvir_2k
Posting Yak Master
180 Posts |
 Posted - 2011-06-08 : 09:49:42
|
| Hi all,I've just set up a replication topology and wanted to test the latency between the publisher and subscriber.So I used tracer tokens to do this.The Publisher to Distributor latency is showing as 2seconds, however the distributor to subscriber latency is just showing as pending.I know the replication is working but this tracer token is not making it to the subscriber.What could be causing this? |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-06-08 : 10:33:11
|
| Are you using Replication Monitor to insert the tracer token, or stored procedure?RepMon is a little buggy and I don't rely solely upon it for much of anything. Might try opening and closing SSMS/RepMon and check again. Is it showing any undistributed commands?That said, if the token isn't making it to the subscriber(s) then replication isn't working. Hopefully you have a field you can update at the subscriber and check for yourself. Then change it back.All replication agents are running ok? No errors? |
 |
|
|
|
|
|
Replication latency - tracer tokens issue.