Spotlight Overview page for SQL Server
Spotlight Overview page for Windows
Spotlight overview page for Unix
How to open a Spotlight Overview page
Sign in to https://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.
From the Heatmap, click on a connection to open the Spotlight Overview page for that connection.
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.
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.
|High||At least one high severity alarm is raised against this component.|
|Medium||At least one medium severity alarm is raised against this component. No high severity alarms are raised.|
|Low||At least one low severity alarm is raised against this component. No high or medium severity alarms are raised.|
|Information||At least one information alarm is raised against this component. No other alarms are raised.|
|Normal||No alarms are raised against this component.|
|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 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.