SQL CPU Configuration

[QuazzieM]

Hey guys,

I need a little guidance from a SQL/VMware guru please..

So we're moving from HyperV to VMware and I have a question around best design for a largish SQL server.

They HyperV VM was configured with 20vCPU and 384GB RAM and was further configured across 2x NUMA nodes. This ran on a host had 2 pCPU with 20cores (80 logical processors) and 512GB RAM.

The new VMware Hosts have 2pCPU with 26cores (104 Logical Processors) and 786GB RAM and the VM will have the same vCPU/vRAM configuration as per the original HyperV version.

The VMware VM is currently configured with 2xSockets with 10xCores for the 20 vCPU

The question I have is that in the HyperV SQL server I can see that there's 2 NUMA Nodes but on the VMware VM there's only a single NUMA node.

So my question is, is the CPU configuration of the VMware VM OK as above or should I look at doing a different setup? Also I assume the NUMA node on the VMware VM is only 1 due to the host having more physical Cores and RAM?? Would it make any difference being a single NUMA node?

Thanks in advance

[daphnissov]

What version of vSphere (vCenter + ESXi) are you running?

[QuazzieM]

Hi,

ESXi v7.0d and vCenter v7.0b

Thanks

[IRIX201110141]

Your "Monster" VM fits into a single NUMA Node. Best thing which can be happen.

You new phys. Server comes with more HW resources than the old one so your 20 vCPU fits onto one pCPU.

Regards,
Joerg

[QuazzieM]

Thanks for the reply.. I figured that was the case but needed to hear it from someone that new better.

Lastly is the VM vCPU configuration as 10xcore and 2xsockets or should I leave it as 20xcores and 1xSocket?

Thanks again

[sk84]

Leave it as 20 cores x 1 socket as long as your VM has less than half of the physical memory and less vCPUs than physical cores.

This might clarify some things (there is no vNUMA behavior change between 6.7 and 7.0): Virtual Machine vCPU and vNUMA Rightsizing - Rules of Thumb - VMware VROOM! Performance Blog