EXERCISE 9.6L AUNCHING R EPLICATION M ONITOR

12. You can use the Replication monitor to find the performance of

the subscribers, which depends on the Latency. Excellent, Good,

Fair, Poor, and Critical (Transactional Replication only) are the

values available for the performance, as shown in Figure 9.14.

Figure 9.14 Performance Monitoring from Replication Monitor

Tracer Tokens

Tracer tokens are to measure the latencies in transaction replication. Tracer tokens

measure how much time has elapsed between the following actions:

A transaction being committed at the Publisher and the corresponding

■

command being inserted in the distribution database at the Distributor

A command being inserted in the distribution database and the corresponding

transaction being committed at a Subscriber

Basically Tracer Tokens can be used to find out which Subscribers are take the

most time to receive a change from the Publisher. Also Tracer Tokens can be used to

find out which Subscribers expected to receive the tracer token, and which, if any,

have not received it.