Specifications

Consolidating multiple SQL Server systems onto
Dell PowerEdge R610 Servers using Microsoft’s Hyper-V
13
Figure 5. CPU settings for a sample virtual machine in
Hyper-V Manager.
Monitoring and tuning Hyper-V
When you install the Hyper-V role in Windows Server 2008, the
installation automatically creates Hyper-V-specific performance
counters at the same time. You can use these performance monitor
counters to monitor your VM resource utilization and then adjust
your resource controls as necessary.
• NOTE: Do not rely on the traditional performance counters
inside a guest OS. In a virtualized environment, the
utilization numbers may not be completely accurate.
According to Microsoft, this is because of clock timing
issues. Be sure to use the Hyper-V specific counters from
the host OS.
Two sample counter sets are as follows:
• Hyper-V Hypervisor Logical Processor counters. This
set of counters contains information regarding the logical
processors in your system. For our systems, the number of
logical processors is equal to the number of processor cores.
Because we are using a dual-processor quad-core system
with hyperthreading, we have 16 logical processors.
• Hyper-V Hypervisor Virtual Processor counters. This
set of counters contains information regarding the virtual
processors specific to each virtual machine in your system.