How to: Set Thresholds and Warnings for a Transactional Publication (Replication Monitor)

  • Article

Specify thresholds on the Warnings and Agents tab. If a threshold is met or exceeded, a warning is displayed in Replication Monitor. You can also have an alert sent to you. 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. You cannot set thresholds for these publications.

For transactional replication, you can specify thresholds for the following conditions:

  • Imminent subscription expiration.
  • Latency (the amount of time that elapses between a transaction being committed at the Publisher and the corresponding transaction being committed at the Subscriber).

To view more information about the options on this tab click Help on the menu bar. For information about starting Replication Monitor, see How to: Start Replication Monitor (Replication Monitor).

To set thresholds and warnings for a transactional publication

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

  2. Click the Warnings and Agents tab.

  3. Enable a warning by selecting the appropriate check box: Warn if a subscription will expire within the threshold or Warn if latency exceeds the threshold.

  4. Set a threshold for the warnings in the Threshold column. For example, if you selected Warn if latency exceeds the threshold in step 3, you could select a latency of 60 seconds in the Threshold column.

  5. Click Save Changes.

To configure an alert for a threshold

  1. Click Configure Alerts.

  2. In the Configure Replication Alerts dialog box, select an alert, and then click Configure.

    This dialog box displays alerts for all publication types, including alerts that are not related to monitoring thresholds. For more information, see Setting Thresholds and Warnings in Replication Monitor and Using Alerts for Replication Agent Events.

  3. Set options in the <AlertName> alert properties dialog box:

    • On the General page, click Enable; specify which database the alert should apply to.
    • On the Response page, specify whether an e-mail should be sent and/or a job should be executed.
    • On the Options page, customize the text of the response.

  4. Click OK.

  5. Click Close.

See Also

Concepts

Best Practices for Replication Administration
Monitoring Performance with Replication Monitor
Monitoring Replication with Replication Monitor
Setting Thresholds and Warnings in Replication Monitor

Help and Information

Getting SQL Server 2005 Assistance