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-21 : 15:51:55
|
| I want to measure replication latency. I have two subscriptions to my publication. Whenever I post a tracer token it doesn't give you an option on which subscriber you want to send the token to, it always goes to the first subscriber. Is there anyway you can tell a tracer token which subscriber to go to?There doesn't seem to be an option in sp_posttracertoken. |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-06-21 : 16:07:19
|
| It goes to every subscriber.After posting a tracer token, use sp_helptracertokens to retrieve the tracer_id, then use sp_helptracertokenhistory to measure the latency. This will return a record for each subscriber. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-06-21 : 16:15:30
|
I ate my wheaties today. Ok, really just killing time until I can deploy some scripts   |
|
|
|
ranvir_2k
Posting Yak Master
180 Posts |
Posted - 2011-06-21 : 17:04:03
|
| Ok I understand now. It was because replication hadn't been configured properly to my second subscriber. I'm now seeing two records in the MSTracer_history table for every token.One question I have is this. If the latency to the second subscriber is higher than to the first subscriber, does that mean replication has to wait until the transaction has been applied on the second subscriber before it moves on to applying the next transaction on the first subscriber. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-06-21 : 17:07:26
|
| No. It will continue applying transactions to the 1st. |
|
|
|
ranvir_2k
Posting Yak Master
180 Posts |
Posted - 2011-06-21 : 17:17:10
|
| Ok that answers all of my questions. Thank you all, much appreciated. |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-06-21 : 20:16:11
|
| Glad we could help :) |
|
|
|
|
|
|
Tracer tokens for multiple subscriptions.
Tara Kizer