Jaa


How to: View Information and Perform Tasks for a Publication (Replication Monitor)

Replication Monitor provides the following tabs that include information about the selected publication:

  • All Subscriptions
    This tab displays information about all subscriptions to the selected publication.
  • Warnings and Agents
    This tab displays information about all agents used by the publication and allows you to specify warnings and alerts. For Distributors running versions prior to Microsoft SQL Server 2005, this tab is labeled Agents and only displays information about agents used by the publication. This tab displays information about the following agents:
    • The Snapshot Agent, which is used by all publications.
    • The Log Reader Agent, which is used by all transactional publications.
    • The Queue Reader Agent, which is used by transactional publications that have queued updating subscriptions.
  • Tracer Tokens (transactional replication only, for Distributors running SQL Server 2005 and later).
    This tab allows you to measure latency, the amount of time that elapses between a transaction being committed at the Publisher and the corresponding transaction being committed at the Subscriber.

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 a publication

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

  2. To view and modify publication properties, right-click the publication, and then click Properties.

  3. To view information about subscriptions, click the All Subscriptions tab.

    To view and modify subscription properties, right-click the subscription, and then click Properties. You can also access more detailed information and perform tasks on this tab. For more information, see How to: View Information and Perform Tasks for the Agents Associated With a Subscription (Replication Monitor).

  4. To view information about warnings and agents, click the Warnings and Agents or Agents tab. You can also access more detailed information and perform tasks on this tab. For more information, see How to: How to: View Information and Perform Tasks for the Agents Associated With a Publication (Replication Monitor).

  5. To view information about tracer tokens, click the Tracer Tokens tab. For more information about how to use tracer tokens, see How to: Measure Latency and Validate Connections for Transactional Replication (Replication Monitor).

See Also

Tasks

How to: View and Modify Publication and Article Properties (SQL Server Management Studio)

Concepts

Monitoring Replication with Replication Monitor

Help and Information

Getting SQL Server 2005 Assistance