SQL 2012 and SQL 2014 NUMA Fix

  • Article

SQL 2012 and SQL 2014 NUMA Fix

Typically a SQL Server Cumulative Update release is not a noteworthy event, however SQL Server 2012 SP1 CU9 and SQL Server 2014 CU1 include a fix that is noteworthy from a from a CAT Lab perspective. In short, if you have a NUMA server with 32 or more physical cores you may want to investigate this CU.

If you are seeing waittypes of SOS_PHYS_PAGE_CACHE from the sys.dm_os_wait_stats DMV or spinlocks of CMEMTHREAD or SOS_SUSPEND_QUEUE in the sys.dm_os_spinlock_stats DMV, I would highly encourage you to investigate the new CU sooner rather than later. 

FIX: Performance problems occur in NUMA environments during foreign page processing in SQL Server 2012 or SQL Server 2014

Cumulative update package 9 for SQL Server 2012 Service Pack 1

Cumulative Update 1 for SQL Server 2014