Export (0) Print
Expand All

Monitor Replication Agents

Microsoft SQL Server Replication Monitor provides a systemic view of replication activity, but also makes it straightforward to find information on a specific agent. The following list includes each agent, the tabs in the Replication Monitor on which it can be found, and a link to a topic that explains how to access these tabs:

Microsoft SQL Server Management Studio provides the following dialog boxes for monitoring replication agents:

  • View Snapshot Agent Status (for all publications)

  • View Log Reader Agent Status (for all transactional publications)

  • View Synchronization Status (for all subscriptions; this dialog box allows access to the Distribution Agent and the Merge Agent)

Replication Monitor provides additional information about each agent and provides monitoring for the Queue Reader Agent, if it is used. For more information, see View Information and Perform Tasks for the Agents Associated With a Publication (Replication Monitor), View Information and Perform Tasks for the Agents Associated With a Publication (Replication Monitor), and View Information and Perform Tasks for the Agents Associated With a Subscription (Replication Monitor).

To monitor the Snapshot Agent and Log Reader Agent

  1. Connect to the Publisher in Management Studio, and then expand the server node.

  2. Expand the Replication folder, and then expand the Local Publications folder.

  3. Right-click a publication, and then click View Log Reader Agent Status or View Snapshot Agent Status.

  4. In the View Log Reader Agent Status or View Snapshot Agent Status dialog box:

    • View agent status.

    • Start or stop the agent if necessary.

    • Click Monitor to launch Replication Monitor.

  5. Click Close.

To monitor the Distribution Agent and Merge Agent (from the Publisher)

  1. Connect to the Publisher in Management Studio, and then expand the server node.

  2. Expand the Replication folder, and then expand the Local Publications folder.

  3. Expand the publication for the subscription you want to monitor.

  4. Right-click the subscription, and then click View Synchronization Status.

  5. In the View Synchronization Status dialog box:

    • View agent status.

    • Start or stop the agent if necessary.

    • For push subscriptions, click Monitor to launch Replication Monitor.

    • For pull subscriptions, click View Job History to launch the Log File Viewer, which displays output from the agent log.

  6. Click Close.

To monitor the Distribution Agent and Merge Agent (from the Subscriber)

  1. Connect to the Subscriber in Management Studio, and then expand the server node.

  2. Expand the Replication folder, and then expand the Local Subscriptions folder.

  3. Right-click the subscription you want to monitor, and then click View Synchronization Status.

  4. In the View Synchronization Status dialog box:

    • View agent status.

    • Start or stop the agent if necessary.

    • Click View Job History to launch the Log File Viewer, which displays output from the agent log.

  5. Click Close.

Community Additions

ADD
Show:
© 2014 Microsoft