How to open the Availability drilldown for a SQL Server connection
- Direct your web browser to http://www.spotlightcloud.io. Sign in an click the Monitoring tab. See also Welcome to Spotlight Cloud Monitoring.
- Select a SQL Server connection. Select the Availability drilldown.
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.
Show the number of databases on this instance and the number of those databases that are available.
Indicate the current configuration status for Clustered and Always On.
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.
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.
Show the name of the database.
Avg Availability %
Show the average availability of the database.
Show the status of the database as in ONLINE, RESTORING, RECOVERY_PENDING or RECOVERING.
Show the high availability type. For example: Mirroring.
Selected database panel
Show data for the selected database.
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.
Show properties of the selected database.
Show data for backups of the selected database.
- Last Backup
- Last Backup Full Time
- Last Backup Different time
- Last Backup Log time
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.