An administrator notices that a virtual machine running SQL Server is not performing as expected. vmware.log vmx| W110: NUMA and VCPU hot add are incompatible. Forcing UMA How can the administrator resolve this issue?

Question

An administrator notices that a virtual machine running SQL Server is not performing as expected. vmware.log> vmx| W110: NUMA and VCPU hot add are incompatible. Forcing UMA How can the administrator resolve this issue?

Accepted Answer

A. Power off the virtual machine and disable vCPU hot plug. NUMA optimization and vCPU hot plug are mutually exclusive because enabling hot plug requires the hypervisor to present a flat UMA memory topology to the guest - powering off the VM and disabling vCPU hot plug allows the hypervisor to restore NUMA awareness, resolving the performance issue for the SQL Server workload.

Answer

B. Reinstall VMware Tools. VMware Tools manages guest OS integration features such as drivers and timekeeping, but it has no ability to resolve a NUMA vs. vCPU hot plug architectural conflict in the hypervisor.

Answer

C. Modify the .vmx file to force NUMA and vCPU hot add to function. The NUMA and vCPU hot add incompatibility is a fundamental hypervisor design constraint and cannot be overridden by editing the .vmx file.

Answer

D. Installation third party plug-in to enable NUMA and vCPU hot add to function. No third-party plug-in can reconcile the NUMA and vCPU hot add incompatibility, as it is an inherent limitation of how the VMware hypervisor must present hardware topology when hot plug is enabled.

An administrator notices that a virtual machine running SQL Server is not performing as expected. vmware.log> vmx| W110: NUMA and VCPU hot add are incompatible. Forcing UMA How can the administrator…

Question

Options

How the community answered

Why each option

Topics

Community Discussion