http://sqlserver.ro/forums/17/ShowForum.aspxenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlserver.ro/forums/thread/32.aspxMon, 10 Apr 2006 12:48:59 GMT963f3a18-65dd-4aad-905c-b785cfe1d7c7:32xmldeveloper0http://sqlserver.ro/forums/thread/32.aspxhttp://sqlserver.ro/forums/commentrss.aspx?SectionID=17&PostID=32<P>Which feature of SQL Server 2005&nbsp;allows measuring&nbsp;latency in transactional replication topologies ? The same feature allows validation of&nbsp;the connections between the Publisher, Distributor and Subscribers.</P> <P><A title="The tracer token feature. 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." href="#"><FONT color=#246398>Place the mouse cursor HERE for the answer</FONT></A></P> <P>&nbsp;</P>Reference: "Measuring Latency and Validating Connections for Transactional Replication" <A href="http://msdn2.microsoft.com/en-US/library/ms151178(SQL.90).aspx">http://msdn2.microsoft.com/en-US/library/ms151178(SQL.90).aspx</A>