Spotlight on SQL Server 10.0.3 - Getting Started Guide

Replication - Publisher Failure 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 - Publisher Failure alarm alerts you to any publishers that have failed.

When this alarm occurs:

• Look at the Publication grid on the Publications page of the Activity drilldown to see which publisher failed.
• Look at the history of the agent involved. To do this:

1. Go to the Publications grid on the Publications page in the Activity drilldown.
2. Select the affected publication.
3. Click the Agents tab.
4. In the Agent column of the Agents grid, click the link for the affected agent.
5. Click the Sessions tab.
6. Select the session in the Sessions grid. The informational and error messages logged for that session are shown in the Top 200 Actions 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 publishers. See "Configure Keyed Alarms" (page 1) for more information.

Related Topics

Spotlight on SQL Server Replication Alarms (page 1)

Activity Drilldown (page 1)