What’s the issue?
Trace flag 1117 is not enabled globally. This trace flag is recommended for SQL Server 2014 and earlier.
Why is this a problem?
Enabling trace flag 1117 allows all files in a file group to grow at the same time. If you have set your tempdb files to grow equally, this means they will all grow when one grows, which should reduce 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. Just be aware this is an instance level setting that affects all databases, so you may not want to enable it if you do not want all files in the filegroups of your user databases to also grow simultaneously.
Read more…
TEMPDB – Files and Trace Flags and Updates, Oh My! | Microsoft Learn
