Spotlight on SQL Server 10.0.3 - Getting Started Guide

Replication - Undistributed Commands Alarm

Note: This feature requires Spotlight on SQL Server Enterprise. Spotlight on SQL Server Replication is available for SQL Server 2005 and later.

The Replication - Undistributed Commands alarm becomes active when the number of undistributed commands exceeds a threshold. Undistributed commands are commands in the distribution database that have not been delivered to the selected subscriber.

When this alarm occurs:

• Look at the history of the affected subscription. To do this:

1. Go to the Subscriptions grid on the Subscriptions page in the Activity drilldown.
2. Select the affected subscription.
3. In the Sessions of the Log Reader Agent grid, select a session. The informational and error messages logged for that session are shown in the Top 200 Actions grid.

Note: If you select a merge publication in the subscription grid, the Sessions grid is displayed. Selecting a session displays the Session Articles grid.

Tips:

• You can configure this alarm to ignore certain values. See "Configure an Alarm to Ignore Certain Values" (page 1) for more information.

• You can configure different alarm severities for specific subscriptions. See "Configure Keyed Alarms" (page 1) for more information.

Related Topics

Spotlight on SQL Server Replication Alarms (page 1)

Activity Drilldown (page 1)