Do I need to enable Trace Flag 1117 for equally sized data files?
2
votes
1
answer
456
views
I was reading about fill proportional algorithm in SQL Server and then I recalled TF1117 . BOL states:
> When a file in the filegroup meets the autogrow threshold, all files
> in the filegroup grow. This trace flag affects all databases and is
> recommended only if every database is safe to be grow all files in a
> filegroup by the same amount.
What I can't understand is if data files are filling proportionally, won't they auto-grow proportionally either? In that case we can't omit using TF1117.
**EDIT**
Here is the version of SQL Server

Asked by Rauf Asadov
(1313 rep)
Jan 23, 2020, 01:51 PM
Last activity: Jan 23, 2020, 02:22 PM
Last activity: Jan 23, 2020, 02:22 PM