Share via

How to: Set Thresholds and Warnings for a Merge 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 merge replication, you can specify thresholds for the following conditions:

  • Imminent subscription expiration.
  • Exceeding the specified synchronization time.
  • Falling short of processing the specified number of rows in a given amount of time.

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 merge 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
    • Warn if a merge length for dialup connections exceeds the threshold
    • Warn if a merge length for LAN connections exceeds the threshold
    • Warn if rows merged per second for LAN connections is less than the threshold
    • Warn if rows merged per second for dialup connections is less than the threshold

  4. Set thresholds for the warnings in the Threshold column. For example, if you selected Warn if a merge length for dialup connections exceeds the threshold in step 3, you could select a time of 10 minutes 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