SQL CPU Configuration

This post was originally published on this site

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

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.