0

I have installed a SQL Server 2022 Developer Edition on an EC2 instance with Windows Server 2022 and installed the latest cumulative update (16.0.4115.5). When I run DBCC TRACESTATUS there are 39 Global Trace Flags turned on and I have not been able to find information on any of them anywhere, e.g. 4511. There are no trace flags as startup parameters.

At installation I choose Fulltext indexes and Polybase as extra features.

If I turn off all the trace flags and restart the server then they are turned back on automatically.

What are these trace flags? Part of cumulative update? Why can I not find any information on any of them?

Improve this question

1 Answer 1

Reset to default
1

I have installed a SQL Server 2022 Developer Edition on an EC2 instance

When I run DBCC TRACESTATUS there are 39 Global Trace Flags turned on

What are these trace flags? Part of cumulative update?

You'll have to ask either Amazon or Microsoft, whether or not they'll tell you is up to the fates.

You're utilizing Amazon's services, there are probably some reasons that those are enabled. Microsoft may provide trace flags to change behaviors that are more relevant to hosting providers and may require other integrations.

Why can I not find any information on any of them?

Microsoft does not publish a full list of trace flags and their usage, however some are published.

Improve this answer
13
  • So SQL setup will check and if host is EC2 then it will enable extra trace flags?
    – xhr489
    Commented Apr 23 at 12:03
  • @xhr489 It sounds very strange to me. We have 2019 on EC2 and the only trace flag that DBCC TRACESTATUS shows is 1222, and it was ME to enable it as I want deadlock graphs to be written to errorlog
    – sepupic
    Commented Apr 23 at 12:49
  • @xhr489 Do you see these flags in the Configuration Manager as startup parameters?
    – sepupic
    Commented Apr 23 at 12:51
  • @sepupic: No there are no TF as startup parameters.
    – xhr489
    Commented Apr 23 at 12:55
  • @xhr489 You can check for it in errorlog: exec xp_readerrorlog 0,1,N'dbcc traceon' at least you'll see WHEN they were enabled. Then you can think what program did that
    – sepupic
    Commented Apr 23 at 13:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.