Wednesday, August 17, 2011

Benefits of Using soft-NUMA

SQL Server is Non-Uniform Memory Access (NUMA) aware.  SQL Server uses NUMA out of the box without additional configuration.

SQL Server also allows you to group CPUs into nodes.  This is referred to as soft-NUMA. You usually configure soft-NUMA when you have many CPUs and do not have hardware NUMA, but you can also use soft-NUMA to subdivide hardware NUMA nodes into smaller groups.  Only the SQL Scheduler and SQL Network Interface use soft-NUMA.

Why use soft-NUMA?

The benefits of soft-NUMA include reducing I/O and lazy writer bottlenecks on computers with many CPUs and no hardware NUMA.  Configuring four soft-NUMA nodes provides four I/O threads and four lazy writer threads, which could increase performance.

Details on MSDN here.

No comments:

Post a Comment