Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

How to: Monitor Replication Agents from Management Studio (SQL Server Management Studio)

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 How to: View Information and Perform Tasks for the Agents Associated With a Publication (Replication Monitor) and How to: View Information and Perform Tasks for the Agents Associated With a Subscription (Replication Monitor).

  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.

  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.

  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:
© 2015 Microsoft