Trace Flag 1117 Growth and Contention

Published Mar 15 2019 01:36 PM 1,847 Views
Microsoft

First published on MSDN on Jul 18, 2017
In this video I talk about Trace Flag 1117 and how it was designed to help keep data file growth with multiple data files in TempDB consistent.  You'll see how growth occurs if the files are disproportionate and also the effect it has on TempDB contention with SQL Server special pages (PFS, GAM, SGAM).

For more on the behavior of Trace Flag 1117 and 1118 in SQL Server 2016 CHECK HERE .

Enjoy!

 

%3CLINGO-SUB%20id%3D%22lingo-sub-371390%22%20slang%3D%22en-US%22%3ETrace%20Flag%201117%20Growth%20and%20Contention%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-371390%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSTRONG%3EFirst%20published%20on%20MSDN%20on%20Jul%2018%2C%202017%20%3C%2FSTRONG%3E%20%3CBR%20%2F%3EIn%20this%20video%20I%20talk%20about%20Trace%20Flag%201117%20and%20how%20it%20was%20designed%20to%20help%20keep%20data%20file%20growth%20with%20multiple%20data%20files%20in%20TempDB%20consistent.%26nbsp%3B%20You'll%20see%20how%20growth%20occurs%20if%20the%20files%20are%20disproportionate%20and%20also%20the%20effect%20it%20has%20on%20TempDB%20contention%20with%20SQL%20Server%20special%20pages%20(PFS%2C%20GAM%2C%20SGAM).%20%3CBR%20%2F%3E%3CBR%20%2F%3EFor%20more%20on%20the%20behavior%20of%20Trace%20Flag%201117%20and%201118%20in%20SQL%20Server%202016%20%3CA%20href%3D%22https%3A%2F%2Fblogs.msdn.microsoft.com%2Fpsssql%2F2016%2F03%2F15%2Fsql-2016-it-just-runs-faster-t1117-and-t1118-changes-for-tempdb-and-user-databases%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3E%20CHECK%20HERE%20%3C%2FA%3E%20.%20%3CBR%20%2F%3E%3CBR%20%2F%3EEnjoy!%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CIFRAME%20src%3D%22https%3A%2F%2Fwww.youtube.com%2Fembed%2FveN06cPifTM%22%20width%3D%22787%22%20height%3D%22515%22%20frameborder%3D%220%22%20allowfullscreen%3D%22allowfullscreen%22%20allow%3D%22accelerometer%3B%20autoplay%3B%20encrypted-media%3B%20gyroscope%3B%20picture-in-picture%22%3E%3C%2FIFRAME%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-TEASER%20id%3D%22lingo-teaser-371390%22%20slang%3D%22en-US%22%3E%3CP%3EFirst%20published%20on%20MSDN%20on%20Jul%2018%2C%202017%20In%20this%20video%20I%20talk%20about%20Trace%20Flag%201117%20and%20how%20it%20was%20designed%20to%20help%20keep%20data%20file%20growth%20with%20multiple%20data%20files%20in%20TempDB%20consistent.%3C%2FP%3E%3C%2FLINGO-TEASER%3E%3CLINGO-LABS%20id%3D%22lingo-labs-371390%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ERyanAdams%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Version history
Last update:
‎Jul 30 2019 03:19 PM
Updated by: