Requires Spotlight Cloud Professional

How to open the Availability drilldown for a SQL Server connection

  1. Direct your web browser to http://www.spotlightcloud.io. Sign in an click the Monitoring tab. See also Welcome to Spotlight Cloud Monitoring.
  2. Select a SQL Server connection. Select the Availability drilldown.

Open the Availability drilldown for a SQL Server connection

Instance panel

Instance panel

Uptime

Show the number of days, hours and minutes that the instance has been available.

Availability during the last 1 hour

Show the proportion of time over the last hour that the instance has been available.

Available databases

Show the number of databases on this instance and the number of those databases that are available.

Configuration

Indicate the current configuration status for Clustered and Always On.

Hostname

Show the name of the host of this instance. If the host is monitored by Spotlight Cloud then click on the hostname to open the Spotlight Overview page for the host.

Outstanding Alarms

Show the number of outstanding alarms of each severity related to the Availability drilldown. Click to open the Alarms panel to drilldown on these alarms.

Databases panel

Databases panel

Database Name

Show the name of the database.

Avg Availability %

Show the average availability of the database.

Status

Show the status of the database as in ONLINE, RESTORING, RECOVERY_PENDING or RECOVERING.

HA Type

Show the high availability type. For example: Mirroring.

Selected database panel

Show data for the selected database.

Outstanding Alarms

Show the number of outstanding alarms of each severity related to the selected database. Click to open the Alarms panel to drilldown on these alarms.

Properties tab

Show properties of the selected database.

Backups tab

Show data for backups of the selected database.

  • Last Backup
  • Last Backup Full Time
  • Last Backup Different time
  • Last Backup Log time

Services panel

For each SQL Server service, show the current state as active, inactive or not configured and when the state last changed. The under chart provides a history of SQL Server services. Hover the mouse over the chart for more detail.

Services panel