You are a database administrator for AIOTestKing.com. Your company has 10 SQL Server 2005 computers in a distributed environment. The SQL Server computers each subscribe to a transactional replication publication. Company policy defines service level agreements (SLAs) for maximum replication latency. You need to verify that the SLAs are being met. What should you do?
A.
Ping each subscriber from the server that hosts the publication database. Record the response time for each.
B.
Record the time stamps on replication-related events in the application event log of each subscriber.
C.
Use tracer tokens to measure and record latency of each subscriber.
D.
Create and execute a stored procedure that verifies the data on each subscriber. Record the execution time of the stored procedure.
Explanation:
Explantion: Transactional replication provides the tracer token feature, which provides a convenient way to measure latency in transactional replication topologies and to validate the connections between the Publisher, Distributor and Subscribers. A token (a small amount of data) is written to the transaction log of the publication database, marked as though it were a typical replicated transaction, and sent through the system, allowing a calculation of:
– How much time elapses between a transaction being committed at the Publisher and the corresponding command being inserted in the distribution database at the Distributor.
– How much time elapses between a command being inserted in the distribution database and the corresponding transaction being committed at a Subscriber.