In a virtual environment the physical CPU of a host is shared by virtual machines and the hypervisor. Multiple processes may want to use the physical CPU of the host at the same time. The virtual machines may have to wait to be scheduled on a CPU.

Gauge

Show 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. The amount of ready time is shown as a percentage of the theoretical maximum CPU available to the virtual machine.

Applicable to SQL Server hosts hosted on VMWare.

Wait Time in nanoseconds

Show 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. Where the SQL Server host is a Windows Server see also the Windows Server connection | CPU drilldown.

The Hyper-V - Virtual Overhead alarm is raised on excessive CPU being used by the hypervisor on this virtual machine.

Applicable to SQL Server hosts hosted on Hyper-V.

Not Virtualized

The SQL Server host is not hosted on a virtual machine or the virtual machine is unknown. Update the SQL Server host connection details from the Spotlight Client, Configure | Connections.