Pages

Sunday, February 5, 2017

NUMA configuration issues on VMs running SQL Server

Non-uniform memory access (NUMA) is a computer memory design used in multiprocessing, where the memory access time depends on the memory location relative to the processor. Under NUMA, a processor can access its own local memory faster than non-local memory (memory local to another processor or memory shared between processors) 1

While configuring a SQL Server environments, it is very important to understand the underlying NUMA architecture. SQL Server has its own scheduling system, the User Mode Scheduler (UMS) which is NUMA aware.