Spotlight on SQL Server 9.5.2 - Getting Started Guide

High Availability Drilldown

The High Availability drilldown shows statistics about the servers involved in transaction log shipping and database mirroring.

To see the High Availability drilldown

1. Select a SQL Server connection from the Spotlight browser.

2. Click Monitor | High Availability.

   

Show all

To investigate...	Look at the...
Transaction Log shipping	Transaction Log Shipping page Note: Log Shipping Monitor History Detail not available for SQL Server 2000.	Transaction Log Shipping Primaries grid Shows statistics relating to the primary database in the log shipping configuration. Transaction Log Shipping Secondaries grid Shows details about the secondary database involved in the log shipping configuration for the primary database selected in the grid above. Transaction Log Shipping History grid If the Primaries page is selected, this grid shows the history for backup jobs on the primary database. If the Secondaries page is selected, this grid shows the history for copy and restore jobs on the secondary database. Transaction Log Shipping Secondaries grid Shows statistics relating to the secondary database in the log shipping configuration.
Database mirroring	Database Mirroring page Note: This feature is not available for SQL Server 2000.	Database Mirroring grid Shows statistics relating to either the principal or mirror server depending on which server Spotlight is connected to. Database Mirroring Details Shows the size of the unsent log on the principal server, the size of the redo queue on the mirror server, and the send rate between the two. Note: Mirroring alarms are disabled by default. It is important to configure alarm thresholds that are appropriate to your environment before enabling these alarms. See "Set Alarm Thresholds" (page 1) for more information.

Related Topics

Spotlight on SQL Server Drilldowns (page 1)

About Spotlight Charts (page 1)

About Spotlight Grids (page 1)