DBA > Job Interview Questions > Microsoft SQL Server FAQs

In SQL Server 2005, you want to monitor your tra

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

In SQL Server 2005, you want to monitor your transactional replication and determine how long it takes for a transaction to move from the publisher to a subscriber. What would you use to help you do this?

Answer
Tracer Tokens.

Explanation
You can use tracer tokens in SQL Server 2005 replication to measure latencies. These are small amounts of data written into your transaction logs.

(Continued on next question...)

Other Job Interview Questions