This article is half-done without your Comment! *** Please share your thoughts via Comment ***
SQL Server 2016 came with the various enhancements and each of those are very important.
In the previous post, I have shared that trace flags 1117 and 1118 are by default on in SQL Server 2016.
You can use trace flag 1117 – When growing a data file grow all files at the same time, so they remain the same size, reducing allocation contention points.
You can use trace flag 1118 – When doing allocations for user tables always allocate full extents. It reduces contention of mixed extent allocations.
In SQL Server 2016, you can enable trace flags 1117 and 1118 at user database level. It replaced by a new ALTER DATABASE setting.
Syntax to enable t1117:
|
1 |
ALTER DATABASE |
Syntax to enable t1118:
|
1 |
ALTER DATABASE |
