The High Availability drilldown shows statistics about the servers involved in transaction log shipping and database mirroring.
To see the High Availability drilldown
Click Monitor | High Availability.
To investigate...
Look at the...
Transaction Log shipping Transaction Log Shipping page
Note: Log Shipping Monitor History Detail not available for SQL Server 2000.
Shows statistics relating to the primary database in the log shipping configuration.
Shows details about the secondary database involved in the log shipping configuration for the primary database selected in the grid above.
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.
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.
Shows statistics relating to either the principal or mirror server depending on which server Spotlight is connected to.
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.
Transaction Log Shipping Primaries grid