Trace flag 1117 and database option autogrow_all_files

sakuraime 2,321 Reputation points

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

    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