You want to find the latency in transmitting data between the distribution and the subscription database in transactional replication. The time difference between the distributor_commit column in Mstracer_tokens table and the subscriber_commit column in Mstracer_history table will give you the latency for the Subscriber server. In which database can you find these two system tables?
A. distribution database
B. publication database
C. subscription database
D. msdb database
Answer:A
You want to find the latency in transmitting data between the distribution and the subscription database in transactional replication. The time difference between the distributor_commit column in Mstracer_tokens table and the subscriber_commit column in Mstracer_history table will give you the latency for the Subscriber server. In which database can you find these two system tables?
A. distribution database B. publication database C. subscription database D. msdb database