I’ve blogged about NUMA a couple of times in the past and we cover it extensively in our Immersion Events, specifically when discussing SQLOS and memory and scheduling management. One of the challenges with this is that laptops are SMP machines, so unless you have a server with hardware NUMA it is impossible to show […]
Jonathan Kehayias
The Rambling DBA
Faking Hardware NUMA on a SMP Machine for Learning and Demos
Posted on: November 15, 2012 9:02 pm
SQL Server and Soft NUMA
Posted on: June 13, 2011 5:38 pm
Friday of last week, Steve Jones (Blog|Twitter) asked a question on the Twitter #sqlhelp tag about SQL Server and Soft NUMA that prompted me to write the long waiting follow up to my first post Understanding Non-Uniform Memory Access/Architectures (NUMA). The question that Steve asked was: @way0utwest: “Do you always have one soft NUMA node? […]
Understanding Non-Uniform Memory Access/Architectures (NUMA)
Posted on: May 24, 2011 1:00 pm
Lately I have been doing a lot of work on SQL Server’s that have had 24 or more processor cores installed in them. Many of these systems utilize hardware non-uniform memory architectures, or NUMA, while a few of them were not. This led me into a good bit of additional research into the differences between […]
