A、Select the Subscription Watch List tab for SQL1. View the Latency column for the SQL2 subscription.
B、Select the All Subscriptions tab for the Pub1 publication. View the Latency column for the SQL2 subscription.
C、Select the Tracer Tokens tab for the Pub1 publication. Select the Insert Tracer Option and wait for the requested latency values for the SQL2 subscription to appear.
D、Select the Subscription Watch List tab for SQL1. Double-click the SQL2 subscription.View the duration details on the Publisher to Distributor History tab as well as on the Distributor to Subscriber History tab.