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 is a solution architect leading, designing and implementing information platform and data centre transformations. He has a track record of delivering projects that provide new functionality, consolidation, and standardisation. He also provides guidance in the broader areas of enterprise IT landscapes and operational best practices. He is also one of 25 Microsoft Certified Architects for SQL Server in the world and a Microsoft Certified Master, and holds architect certification from the Global IT Architect Association, IASA. His technical expertise focuses on Microsoft SQL Server data platforms and cloud infrastructures, primarily in the retail and services sectors.

  • Video