Sample Header Ad - 728x90

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 enter image description here
Asked by Rauf Asadov (1313 rep)
Jan 23, 2020, 01:51 PM
Last activity: Jan 23, 2020, 02:22 PM