SQL SERVER – TempDB and Trace Flag 1117 and 1118 – Not Required


 

Yes, it is true that from SQL Server 2016, Trace Flag 1117 and 1118 are not required. Recently I was hired by a large banking firm to help them with the Comprehensive Database Performance Health Check.

Trace Flag 1117 and 1118 – Not Required

The bank has recently upgraded its database from SQL Server 2022 to SQL Server 2019. After upgrading SQL Server on the new platform out of nowhere they suddenly started to see poor performance. I helped them fixed the performance with the SQL Server. While looking at various details about their system, I realized they had enabled trace flag