Sample Header Ad - 728x90

SQL Server 2022 trace flags

0 votes
1 answer
539 views
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?
Asked by xhr489 (827 rep)
Apr 23, 2024, 10:40 AM
Last activity: Apr 23, 2024, 11:18 AM