Home / server / Questions / 1002791
Accepted
tilkov
Asked: 2020-02-13 06:29:05 +0800 CST

NUMA 1 not used on SQL Server 2008 R2 on Windows Server 2008 R2 on ESXi

  • 772

We've got Microsoft SQL Server 2008 R2 running on Windows Server 2008 R2, virtualized on VMWare ESXi 6.7.0.

The server has 2 CPU sockets with 22 cores each. The VM is allocated 8 sockets with 3 cores each and 64 GB RAM (ServerEnterprise).

Inside the VM i see two NUMA nodes, each with 11 CPUs.

Unfortunately, SQL server uses only the CPUS on NUMA Node 0 and NUMA Node 1 is idling.

What am i doing wrong? Am i limited by licensing or misconfiguration?

Resource monitor screenshot

virtualization windows-server-2008 sql-server vmware-esxi numa

1 Answers

  1. Best Answer

    Answering myself the document the solution.

    SQL Server 2008 R2 Standard is licensed for 4 sockets or 24 cores, whichever is less. With my case, with 8 sockets, only 4 of them were used.

    Switching the VM to 4 sockets, 6 cores each allows us full utilization of the resources.

    • 0