Azure SQL DB Managed Instances: Trace Flags, Ahoy!
When you talk to people from Microsoft
They’re all “aw shucks” about Trace Flags.
- “Don’t really need’em!”
- “Eh, haven’t used one in years.”
- “Sometimes they’re good for troubleshooting, but…”
Then you hop on a managed instance (where you’re not allowed to turn Trace Flags on or off), and you see what they have turned on.
If you head over to Konstantin Taranov’s GitHub repo for Trace Flags, you can decode some of them.
Missing from the list:
- 2591
- 3447 (but 3448 is there, which is supposed to help fix an issue with hung Mirrored databases)
- 3978
- 4141
- 5521
- 7838
- 8037
- 8054
- 8057
- 8063
- 8065
- 9041
- 9537
- 9570
- 9883
- 9905
- 9934
- 9940
- 9941
See where I’m going with this? Konstantin has a GREAT LIST but there are still 19 unknowns enabled on every Managed Instance.
Kinda makes you wonder what all these Trace Flags are up to behind the Redmond Curtain.
If you know what any of them do, feel free to leave a comment — or better yet, add an Issue for Konstantin so he can keep his list up to date.
Some of them are startup Trace Flags, so if you’re aiming to do some poking around, it may not help you to just flip them on.
Thanks for reading!
10 Comments. Leave new
i’m not familiar with any of those yet… but i’m really surprised that 4199 isn’t in the list of enabled trace flags. Even though the database scoped config option QUERY_OPTIMIZER_HOTFIXES *should* be equivalent… cases of it being late and having to catch up keep being discovered.
I’m not either, but perhaps they’d be helpful to people suffering from VM Problems®
😉
I can’t believe it took me 5 years to notice this XTC reference. Trace Flags on MI still haunt us all.
Andrew Notarian, Mayor of Simpleton
And days later, I’m still singing that dang song, hahaha.
-T 174
Can this be enabled on SQL Managed instance or even its required?
If yes, is there a way to enable it permanently? — Not so hopeful as your comment says : (where you’re not allowed to turn Trace Flags on or off), however wanted to confirm 🙂
Just to make sure I understand – you read this line:
> managed instance (where you’re not allowed to turn Trace Flags on or off)
And you’re asking me if trace flags can be turned on in Managed Instances? That’s your question?
Yes… or in other words I can say, I am asking if -T 174 is even needed in managed instances?
Hemanshu, I don’t think you have a promising career in tech. Best of luck on your journey, though.
Well, I’ll keep that in mind Brent! ? Thanks, though!!