MS SQL Server 7.0 Enterprise Manager - Replication FAQ

What is Replication Monitor and how it can be used to monitor replication activity and performance?



Replication Monitor is an interface provided by SQL Server 7.0 Enterprise Manager (EM), which allows you to monitor the activity of each replication agent individually AND the activity of all agents at the publication level.


An X mark will be displayed against the replication agents in case of any errors. Different actions of the replication agents are indicated using different icons.


Replication monitor refreshes the results pane and the server tree every 10 seconds by default. To get more real time information, change these settings, so that the contents of replication monitor are refreshed more often. To do this, right click on the Replication Monitor and select ‘Refresh Rate and Settings’. You can always do a manual refresh by right clicking on the nodes in the server tree and selecting ‘Refresh’. You can also press ‘F5’ key to refresh, when the focus is in the results pane.


By right clicking on the Replication Monitor and selecting ‘Select Columns’ you can customize the information that is being displayed about each agent.


You can change the schedules of the agent, add steps to the agent, and set notifications, by right clicking on the agent and selecting ‘Agent Properties’. You can change or edit the profiles of replication agents by right clicking on the agent and selecting ‘Agent History’. You can view the current error messages and history of the replication agent by right clicking on the agent and selecting ‘Error Details’ and ‘Agent History’ respectively. Also you can stop and start agents by right clicking on the agent.



Please click here for more