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.
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.