Does SQL Server 2016 Require Trace Flag -T8048?


Moved from: bobsql.com

 

Various changes from automatic soft NUMA to CMemThread partitioning have muddied the water around the trace flag –T8048 messaging.

 

Prior to SQL Server 2016 the trace flag –T8048 is used to upgrade (only) NUMA partitioned, CMemThread objects to CPU partitioned based objects.  A few of the most common CMemThread objects have been upgraded to NUMA partitioning, allowing –T8048 to be used as needed for additional partitioning.

 

The three types of CMemThread partitioning and associated details are described in my previous post:  https://blogs.msdn.microsoft.com/psssql/2012/12/20/how-it-works-cmemthread-and-debugging-them/

Keep in mind that the vast majority of CMemThread objects (SQL