Spotlight Overview page for SQL Server

Spotlight Overview page for SQL Server

Spotlight Overview page for Windows

Spotlight Overview page for Windows

Spotlight overview page for Unix

Spotlight Overview page for Unix

How to open a Spotlight Overview page

Sign in to http://www.spotlightcloud.io to see the Monitoring tab. Following sign in you can open this page from the navigation menu top left of the Monitoring screen. Select a connection. When a single connection is selected the initial monitoring page is the Spotlight Overview page.

Select a connection

From the Heatmap, click on a connection to open the Spotlight Overview page for that connection.
Open a connection from the Heatmap

About Spotlight Overview page flows and components

Spotlight Overview page flows and components are tailored to the connection type. Hover your mouse over a component for a description.

Hover over an Overview page component

Component color

If the color of a component is other than green then the component is in an alarm state. If more than one alarm is raised against the component then the color shows the highest severity alarm raised.

Color Severity Description
High color High At least one high severity alarm is raised against this component.
Medium color Medium At least one medium severity alarm is raised against this component. No high severity alarms are raised.
Low color Low At least one low severity alarm is raised against this component. No high or medium severity alarms are raised.
Information color Information At least one information alarm is raised against this component. No other alarms are raised.
Normal color Normal No alarms are raised against this component.
Disabled color Disabled Spotlight Cloud is not monitoring this component. During a Planned Outage all Spotlight Overview page controls are disabled except Status.

Flows and components in an alarm state

From the top right corner of the page, click Open the alarms panel to open the Alarms panel.

How to configure the Virtualization Overhead component

The SQL Server and Windows Server Overview pages have a Virtualization Overhead component.

If the Windows Server or SQL Server host is hosted on VMware then the Virtualization Overhead component takes the form of a gauge. It shows the percentage of CPU that is unavailable to this virtual machine because it is being consumed either by other virtual machines or by VMware itself.

If the Windows Server or SQL Server host is hosted on Hyper-V then the component shows wait time in nanoseconds. This shows the average time the virtual machine spent waiting for CPU over the collection interval (average 5 minutes). The average queue time should remain under 60,000ns. If the average queue time exceeds 60,000ns then a Hyper-V CPU wait time per dispatch alarm is raised. A high alarm is raised if the average queue time exceeds 100,000ns.

If the Virtualization Overhead component says Not Virtualized then either the Windows Server is not hosted on a virtual machine or the virtual machine is unknown to Spotlight Cloud. Use the Spotlight Cloud Diagnostic Server App to update Windows Server Connection Details.