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?

SELECT @@VERSION

DBCC TRACESTATUS

listflags

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.

Advertisements

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:

WordPress.com Logo

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

Google photo

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

Twitter picture

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

Facebook photo

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

Connecting to %s