Export (0) Print
Expand All
Expand Minimize
2 out of 2 rated this helpful - Rate this topic

How to: View Information and Perform Tasks for the Agents Associated With a Subscription (Replication Monitor)

Replication Monitor provides two tabs that allow access to information about the agent(s) associated with a subscription:

  • All Subscriptions

    This tab displays information about all subscriptions to the selected publication.

  • Subscription Watch List

    This tab is intended to display information about subscriptions from all publications available at the selected Publisher that have errors, warnings, or the poorest performance. This tab is not displayed for Distributors running versions prior to Microsoft SQL Server 2005.

For more information about the options on each tab, click the tab in the right pane, and then click Help on the menu bar. For information about starting Replication Monitor, see How to: Start Replication Monitor (Replication Monitor).

To view information and perform tasks for the agents associated with a subscription (All Subscriptions tab)

  1. Expand a Publisher group in the left pane, expand a Publisher, and then click a publication.

  2. Click the All Subscriptions tab to view information about subscriptions. You can also access more detailed information and perform tasks on this tab:

    • To view detailed information about the agent associated with a subscription, right-click the subscription, and then click View Details. Detailed information includes: agent history and error messages; performance statistics for transactional replication; and article-level synchronization statistics for merge replication.

      The tabs on the detail window that is launched depend on the type of subscription: for snapshot subscriptions, the tab is Distributor to Subscriber History; for transactional subscriptions, the tabs are Publisher to Distributor History, Distributor to Subscriber History, and Undistributed Commands; for merge subscriptions, the tab is Synchronization History.

    • To synchronize a push subscription, right-click the subscription, and then click Start Synchronizing.

    • To reinitialize a subscription, right-click the subscription, and then click Reinitialize Subscription.

    • To validate a single merge subscription, right-click the subscription, and then click Validate Subscription. To validate all subscriptions to a merge publication, right-click the publication, and then click Validate All Subscriptions; to validate all subscriptions for a transactional publication, right-click the publication, and then click Validate Subscriptions.

    • To manage profiles for the agent, right-click the agent, and then click Agent Profile. For more information, see How to: Work with Replication Agent Profiles (SQL Server Management Studio).

To view information and perform tasks for the agents associated with a subscription (Subscription Watch List tab)

  1. Expand a Publisher group in the left pane, and then click a Publisher.

  2. Click the Subscription Watch List tab to view information about subscriptions. You can also access more detailed information and perform tasks on this tab:

    • To view detailed information about the agent associated with a subscription, right-click the subscription, and then click View Details. Detailed information includes: agent history and error messages; performance statistics for transactional replication; and article-level synchronization statistics for merge replication.

      The tabs on the detail window that is launched depend on the type of subscription: for snapshot subscriptions, the tab is Distributor to Subscriber History; for transactional subscriptions, the tabs are Publisher to Distributor History, Distributor to Subscriber History, and Performance; for merge subscriptions, the tab is Synchronization History.

    • To synchronize a push subscription, right-click the subscription, and then click Start Synchronizing.

    • To reinitialize a subscription, right-click the subscription, and then click Reinitialize Subscription.

    • To validate a single merge subscription, right-click the subscription, and then click Validate Subscription. To validate all subscriptions to a merge publication, right-click the publication, and then click Validate All Subscriptions; to validate all subscriptions for a transactional publication, right-click the publication, and then click Validate Subscriptions.

    • To manage profiles for the agent, right-click the agent, and then click Agent Profile. For more information, see How to: Work with Replication Agent Profiles (SQL Server Management Studio).

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.