There’s more to non-uniform memory access (NUMA) than physical boundaries in your server hardware. Putting the DEEP back into Deep Dive, Rob and Shawn will use this session to deliver everything you ever wanted to know about pNUMA & vNUMA settings within VMware vSphere, Windows, & SQL Server to aid you in getting the settings right to maximize performance. In addition to an overview on NUMA, we’ll discuss some nuances of NUMA that are not commonly known, effects of memory & CPU hot-add, selecting cores vs. sockets for your VMs, default calculation behavior, performance penalties for getting it wrong, and MORE!
Deep Dive on pNUMA & vNUMA: Save Your SQL VMs from Certain DoomA!
by khadmin | Sep 9, 2020