SQL Server 2016: How to enable trace flag 1117 and flag 1118 on Database

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:

Syntax to enable t1118:


Please share your ideas and opinions about this topic with me, your contribution will add true value to this topic.
If anyone has doubts on this topic then please do let me know by leaving comments or send me an email.

If you like this post, then please share it with others.
Please follow dbrnd.com, I will share my experience towards the success of Database Research and Development Activity.

I put up a post every day, please keep reading and learning.
Discover Yourself, Happy Blogging !
Anvesh M. Patel.

More from dbrnd.com

Leave a Reply

Be the First to Comment!

Notify of
avatar
wpDiscuz