Trace flag 1117 and database option autogrow_all_files

sakuraime 2,331

https://learn.microsoft.com/en-us/archive/blogs/psssql/sql-2016-it-just-runs-faster-t1117-and-t1118-changes-for-tempdb-and-user-databases

while trace flag 1117 is default enabled on SQL Server 2016 and the database option autogrow_all_files is still required ??

Accepted answer

Martin Cairney 2,256 Reputation points

2021-01-18T07:07:25.087+00:00

Starting with SQL Server 2016 (13.x) the file growth is controlled by the AUTOGROW_SINGLE_FILE and AUTOGROW_ALL_FILES option of ALTER DATABASE, and trace flag 1117 has no effect.

Therefore you have it the wrong way around - use the AUTOGROW_ALL_FILES option of ALTER DATABASE and ignore the Trace Flag as it has no effect.
Please sign in to rate this answer.

2 people found this answer helpful.
sakuraime 2,331 Reputation points

2021-01-18T14:23:47.86+00:00

thanks . I think so !!

tibor_karaszi@hotmail.com 4,311 Reputation points

2021-01-18T14:27:14.557+00:00

Also, the setting is a filegroup setting, not a database-wide setting. There's an option for this in SSMS, as of version 18. And it is on by default for tempdb, but not other databases/filegroups.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

0 additional answers

Your answer