Friday, April 15, 2016

@sqL_handLe don't forget about trace flags 6498, 7470 and 8075

In my race to retire trace flags in SQL Server 2016 I need not forget about trace flags 6498, 7470 and 8075.  Not sure if these fixes are included by default in SQL Server 2016.  If I find out they are included by default in SQL Server 2016 I'll update this post... and retire these trace flags in my systems in tandem with adoption of SQL Server 2016 :-)

Trace flag 6498 introduced in:
SQL Server 2014 RTM SP6
SQL Server 2014 SP1 CU1
Large query compilation waits on RESOURCE_SEMAPHORE_QUERY_COMPILE in SQL Server 2014
https://support.microsoft.com/en-us/kb/3024815

Trace flag 7470 introduced in:
SQL Server 2012 SP2 CU8
SQL Server 2014 RTM CU10
SQL Server 2014 SP1 CU3

FIX: Sort operator spills to tempdb in SQL Server 2012 or SQL Server 2014 when estimated number of rows and row size are correct
https://support.microsoft.com/en-us/kb/3088480

Trace flag 8075 introduced in:
SQL Server 2012 SP2 CU8
SQL Server 2014 RTM CU10
SQL Server 2014 SP1 CU4

FIX: Out of memory error when the virtual address space of the SQL Server process is very low on available memory
https://support.microsoft.com/en-us/kb/3074434

No comments:

Post a Comment