Share via

Publication Information, Warnings and Agents (Merge Publication, SQL Server 2005 and Later)

  • Article

The Warnings and Agents tab is available for Distributors running SQL Server 2005 and later versions; the Agents tab is available for previous versions. The Warnings and Agents tab allows you to perform the following tasks for the selected publication:

  • Enable warnings.
  • Specify thresholds associated with warnings.
  • Define alerts associated with warnings.
  • View summary information on the Snapshot Agent for the publication.
  • Access more detailed information about the Snapshot Agent.

Warnings, Thresholds, and Alerts

By default, Replication Monitor displays warnings for uninitialized subscriptions: a status of Uninitialized subscription is displayed as a warning in the Status column of pages that include subscription information. For merge publications, you can specify whether these additional conditions result in warnings:

  • Imminent subscription expiration.
    This corresponds to the option Warn if a subscription will expire within the threshold. If the specified threshold is met or exceeded, the subscription status is displayed as Expiring soon/Expired (unless an issue with a higher priority needs to be displayed).
  • Exceeding the specified synchronization time.
    This corresponds to the options Warn if a merge length for dialup connections exceeds the threshold and Warn if a merge length for LAN connections exceeds the threshold. Both of these thresholds can be set, but only one is used during a given synchronization. The Merge Agent applies the appropriate threshold based on the connection type.
    If the specified threshold is met or exceeded, the subscription status is displayed as Long-running merge (unless an issue with a higher priority needs to be displayed).
  • Falling short of processing the specified number of rows in a given amount of time.
    This corresponds to the options Warn if rows merged per second for dialup connections is less than the threshold and Warn if a merge length for LAN connections exceeds the threshold. Both of these thresholds can be set, but only one is used during a given synchronization. The Merge Agent applies the appropriate threshold based on the connection type.
    If the specified threshold is met or exceeded, the subscription status is displayed as Performance critical (unless an issue with a higher priority needs to be displayed).

When you enable a warning, you also set a threshold. For example, if you enable the warning Warn if a merge length for LAN connections exceeds the threshold, set the maximum allowable length of time for a merge synchronization.

In addition to displaying a warning in Replication Monitor, reaching a threshold can also trigger an alert. Alerts are defined by clicking Configure Alerts and providing information in the Configure Replication Alerts dialog box.

Options

For more detailed information and tasks related to the Snapshot Agent, right-click the row for the agent, and then click an option on the shortcut menu.

  • Enabled
    Select to enable a warning and specify a threshold.
  • Warning
    A description of the warning associated with a threshold.
  • Threshold
    Specify a value for the threshold.
  • Configure Alerts
    Select a row in the Warnings grid, and click Configure Alerts to launch the Configure Replication Alerts dialog box. The dialog box allows you to define an alert, which is associated with the selected threshold and warning.

  • Discard Changes
    Click to discard any changes to warnings and thresholds.

    Note

    Clicking Discard Changes does not affect alerts defined in the Configure Replication Alerts dialog box.

  • Save Changes
    Click to save any changes to warnings and thresholds.

  • Status
    The status of the Snapshot Agent. The following list shows the possible status values:

    • Error
    • Retrying failed commands
    • Not running
    • Running
  • Last Start Time
    The last time the agent started.
  • Duration
    The amount of time the agent has run. The time represents elapsed time if the agent is currently running and total time if the agent has run previously.

See Also

Other Resources

How to: Start Replication Monitor (Replication Monitor)
How to: View Information and Perform Tasks for a Publication (Replication Monitor)
How to: View Information and Perform Tasks for the Agents Associated With a Publication (Replication Monitor)
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