You can use the Microsoft SQL Server Management Studio to monitor replication activity. See your SQL Server documentation for information on the Microsoft SQL Server Management Studio, .
-
From the Microsoft SQL Server Management Studio, in the Object Explorer, expand the server instance name that you want to monitor.
-
Right-click Replication, and select Launch Replication Monitor.
-
One very useful feature of the Replication Monitor is "tracer tokens" which allow you to measure the latency between the Publisher, Distributor, and the Subscriber. It is also useful to check the activity levels between the servers.
-
You can also use the Warnings and Agents feature to configure alerts so an administrator can be notified by e-mail of any agent failures.