The NUMA internals of SQL Server 2012

Most servers we deploy today use a NUMA rather than an SMP mainboard architecture and while we might conceptually understand what that means we often don’t appreciate the subtle changes to how Windows and SQLOS work when they run on a NUMA architecture server. To make things even more interesting, we can deploy Soft-NUMA ourselves to request some of the behaviour changes ourselves.

This session will cover:

  • what is NUMA and why it exists,
  • how Windows responds to NUMA hardware
  • how SQL Server 2012 changes its behaviour in the NUMA world. 

We’ll then look at some of the benefits NUMA brings us and how we sometimes need to adapt our monitoring for the NUMA world.

Presented by Gavin Payne at SQLBits X
  • Downloads
  • SpeakerBIO

    Gavin Payne is the principal architect for Coeo and a Microsoft Certified Architect and Microsoft Certified Master for SQL Server.  His role is to advise IT leadership on what they should do, help their business leadership understand why and help their technical teams understand how.  Gavin leads organisations through their data platform transformation and modernisation programmes.

  • Video