Tag: session

Trace Flag 4199: No Per-Session Override if You Enable it Globally

on April 19, 2017

Tags: global , optimization , session , tf , trace-flag-4199 , performance-tuning

You can enable and disable trace flags either globally or per-session in SQL Server.

This makes it seem like perhaps if you enable optimization trace flag 4199 globally for all sessions, you might be able to disable it per-session.

But that’s NOT how it works.