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 |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2012-12-10 : 09:17:34
|
| i have 2 servers, which have transactional replication between them,connected physically between them with a cross cable.the subscriber pull's the data from data.The thing is that in REPLICATION MONITOR I see the column LATENCY show 52 minutes,However when I use the Replication Monitor script taken from here:http://sqlfool.com/tag/monitor/I get data that overall_latency is no more than 3-4 seconds, distributor_latency 3-4 seconds and subscriber_latency is zero.The script also checks using INSERT TOKEN where everything is normal, when I do the same test from the REPLICATION MONITOR I get to 50 minutes.How can i figure out which results are correct, because on the Distributor to subscriber History i see all the transactions and the tables are up to date?this problem makes monitoring the replication less reliable.any idea? |
|
|
|
|
|
replication latency