What’s the issue?
Trace flag 1118 is not enabled globally. This trace flag is recommended for SQL Server 2014 and earlier.
Why is this a problem?
Enabling trace flag 1118 tells SQL Server to avoid mixed extents by allocating each 64 KB extent to a single object. Doing this results in slightly more data pages, but reduces the possibility of contention.
What should you do about this?
We recommend enabling trace flag 1117 for SQL Server 2014 and earlier. This trace flag is not needed in SQL Server 2016 or later because it is the default behavior.
Read more…
TEMPDB – Files and Trace Flags and Updates, Oh My! | Microsoft Learn
