Deep Dive on pNUMA & vNUMA – Save Your SQL VMs from Certain DoomA! (400)

Speaker: Rob Girard

There’s more to non-uniform memory access (NUMA) than physical boundaries in your server hardware. Putting the DEEP back into Deep Dive, this session will 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!