Database Reference
In-Depth Information
Figure 5.6
Sample NUMA architecture.
Note
uniform_memory_access
.
NUMA is configured in the BIOS of your physical servers. Always read your server
vendor's documentation, but typically NUMA is enabled by disabling node interleaving
in the BIOS. Having NUMA enabled is usually the default setting.
VMware has supported NUMA since ESX 2.5. This means that if your physical
hardware both supports and is configured for NUMA, the hypervisor will work to
maximize performance of the system. There are features in the vSphere platform that we
will discuss in the paragraphs that follow because they will come into play when
architecting SQL Server databases to run on a vSphere host.
The first feature is Wide NUMA. Wide NUMA was introduced in vSphere 4.1. Using
the image in
Figure 5.6
,
we have a four-socket, six-core system with hyper-threading
