Share via

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

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 snapshot replication, you can specify a threshold for imminent subscription expiration.

To view more information about the options on this tab click Help on the top menu. 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 check box Warn if a subscription will expire within the threshold.

  4. Set a threshold for the warning in the Threshold column. For example, you could select a value of 70% 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


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