In this topic, we will use tracer tokens to verify that changes are being replicated to the subscriber and to determine latency. Latency is the time it takes for a change made at the publisher to appear to the subscriber.
- Connect to the publisher in SQL Server Management Studio. Expand the server node, right-click the Replication folder, and then select Launch Replication Monitor:
- Expand a publisher group in the left pane, expand the publisher instance, and then select the AdvWorksProductTrans publication.a. Select the Tracer Tokens tab.
b. Select Insert Tracer.
c. View elapsed time for the tracer token in the following columns: Publisher to Distributor, Distributor to Subscriber, Total Latency. A value of Pending indicates that the token has not reached a specified point.
From above screen you can see the latency from publisher to distributor and distributor to subscriber.
No comments:
Post a Comment