Trace flag 1117 and database option autogrow_all_files

sakuraime 2,321 Reputation points
2021-01-18T04:14:44.407+00:00

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 ??

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,877 questions
0 comments No comments
{count} votes

Accepted answer
  1. Martin Cairney 2,241 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.

    2 people found this answer helpful.

0 additional answers

Sort by: Most helpful