Azure SQL Database and Trace Flags

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?




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.


3 thoughts on “Azure SQL Database and Trace Flags

  1. Pingback: Dew Drop – February 26, 2019 (#2907) | Morning Dew

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s