• Facebook - Black Circle
  • Twitter Round
  • Instagram Black Round
  • LinkedIn - Black Circle

SEARCH BY TAGS: 

Please reload

RECENT POSTS: 

FOLLOW ME:

  • Facebook - Black Circle
  • Twitter - Black Circle
  • Instagram - Black Circle
  • LinkedIn - Black Circle

New TempDB TraceFlag

July 19, 2018

 

In the past we're used to enabling Traceflags 1117 and 1118 in order to help with TempDB Contention. With the release of SQL 2016, these were no longer needed...however

 

Now it's been suggested to enable Traceflag 3427.

 

Why? Because  a new type of contention has emerged called "Metadata contention".  The quick explanation of this is that Metadata contention is contention on system objects in tempdb that are used to track temp tables. 

 

Whenever we remove something from cache, we usually have to adjust the tables that carry the metadata. So with the way things are going, now wer're seeing contention on the deletes from this cache. In the past this has not been a huge issue, but SQL 2016 has shown a notable increase in the table metadata.

 

So, if you're running SQL 2016+ it might be good to enable TF 3427, and make it part of your standard setup.

 

For more in depth information, check out this post.

 

 

 

Share on Facebook
Share on Twitter
Please reload