You cannot enable trace flags (globally or by session) within Azure SQL Database but did you know that some global trace flags are enabled by default?
What is on?
SELECT @@VERSION
DBCC TRACESTATUS
Well, a lot of these are not documented anywhere. Some are for example trace flag 1800 which enables SQL Server optimization when disks of different sector sizes are used for primary and secondary replica log files, in SQL Server Always On AGs and Log Shipping environments. Other trace flags? Who knows! Well I would love a trip to Redmond to find out….I’ll keep dreaming.
Pingback: Dew Drop – February 26, 2019 (#2907) | Morning Dew
Hello, thanks for the post. Some of this flags documented here https://github.com/ktaranov/sqlserver-kit/blob/master/SQL%20Server%20Trace%20Flag.md (for example: 1800, 2551, 8015 and others) but some flags still not known https://github.com/ktaranov/sqlserver-kit/blob/master/SQL%20Server%20Trace%20Flag.md#unknown-trace-flags
LikeLike
Thanks for sharing this link
LikeLike