You are employed as a database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. The Domain.com network contains two SQL Server 2005 computers named Certkiller -DB01 and Certkiller -DB02.
Certkiller -DB01 and Certkiller -DB02 both take part in replication. Certkiller -DB01 is the Publisher and Distributor of a publication named CK_Pub1. CK_Pub1 is the only publication on Certkiller -DB01 while Certkiller -DB02 is the only Subscriber. The CIO requests a status report regarding the replication latencies.
A Domain.com user named Rory Allen is a member of the Research and Development department. You instruct him to determine the current latencies between the Publisher and Distributor as well as between the Distributor and Subscriber using the Replication Monitor on Certkiller -DB01.
What should Rory Allen do?
A.
Rory Allen should select the Subscription Watch List tab for Certkiller -DB01.
Then he should double-click the Certkiller -DB02 subscription.
Thereafter he can view the duration details on the Publisher to Distributor History tab as well as the Distributor to Subscriber History tab.
B.
It is important that Rory Allen select the Tracer Tokens tab for the Pub1 publication.
Thereafter he can select the Insert Tracer option and wait for the requested latency values for the Certkiller -DB02 subscription to appear.
C.
The Subscription Watch List tab for Certkiller -DB01 should be selected.
Thereafter Rory Allen can view the Latency column for the Certkiller -DB02 subscription.
D.
Rory Allen needs to select the All Subscriptions tab for the Pub1 publication.
Thereafter Rory Allen can view the Latency column for the Certkiller -DB02 subscription.
Explanation:
Tracer tokens are a new feature of the transactional replication engine in SQL Server 2005. They are specialized transactions that are used to gain timing information. Since tracer tokens are picked up by the replication engine and transit with every other transaction, they can be used to determine the amount of time it takes a transaction to move from the publisher to distributor and then from the distributor to each subscriber. With this piece of information, you can now answer the two most predominant questions for replication: How far behind am I and how long will it take to catch up?