We have a SQL Server 2012 SP 2 CU 8 instance in a VMWare host. The operating system is Windows Server 2012 R2.
Windows Task Manager says that we have two sockets and 8 virtual cores. This number corresponds with the actual hardware beneath the guest.
In Task Manager I also can't change the view to NUMA nodes.
Also this snippet from Glen Berrys diagnostics queries gives me this information
EXEC sys.xp_readerrorlog 0, 1, N'detected', N'socket';
SQL Server detected 2 sockets with 4 cores per socket and 4 logical processors per socket, 8 total logical processors; using 8 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
From all this information i can suspect that we are running on only one NUMA node but across two sockets.
- Is it right that we are running on only one NUMA node?
- Can this hurt performance even when everything is located on one NUMA node?
- What component exactly dictates the NUMA boundaries? E.g. if I have a two socket mainboard with two Intel E5 processors does the mainboard dictate how many NUMA nodes I have or the processor.
I think there is a lot of misinformation out there about NUMA nodes. If someone can answer my question or point to a useful resource that explains this concept in detail that would be really appreciated.