June 5, 2026 at 5:26 am
Are there any good articles on all the trace flags that are enabled on SQL Server when you install PolyBase? From what I can see most of them are undocumented. which seems a bit odd given Microsoft are forcing these on the environment.
These 37 odd trace flags have been added to my client's SQL 2022 servers where PolyBase is installed. These aren't in the SQL Startup Parameters or the registry.
10063, 10064, 10274, 10276, 10287, 10289, 10295, 10910, 10911, 11532, 12905, 12906, 12908, 12909, 12912, 12921, 12926, 12937, 12944, 12945, 12946, 12951, 12957, 12970, 12986, 12992, 13700, 4511, 4518, 4812, 4816, 4818, 4821, 4823, 4824, 4830, and 4838
While most are undocumented, some seem odd to be enabled on SQL Server 2022. e.g. "Trace flag 4812 is used to enable the use of the new cardinality estimator for queries that are executed in compatibility level 130 or higher. " I thought by compatibility level 160 (SQL 2022), the new cardinality estimator was default.
Leo
Nothing in life is ever so complicated that with a little work it can't be made more complicated.
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply