Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.
Cumulative update package 9 for SQL Server 2012 Service Pack 1