Questions tagged [trace-flags]
A SQL Server configuration option used to temporarily enable or disable specific server behaviours.
36 questions
1
vote
1
answer
84
views
What does trace flag 11024 do?
Context
I have been experimenting with incremental statistics a lot. I do not know of any online resource about them that I have not read. Despite all of this, I just don't understand what trace flag ...
- 1,288
2
votes
1
answer
354
views
When does a subquery choose a join instead as a logical operator?
so the simplification in the algebrizer is supposed to convert some of the subqueries to inner or outer joins.
for example, i tried this
DBCC TRACEON(3604)
USE ContosoRetailDW
BEGIN TRAN
SELECT ...
- 167
0
votes
1
answer
141
views
Add RowVersion column to a very large table
We need to add rowversion column to a very large table. We are on SQL 2022 and came across this post where Paul White mentioned about trace flag - 4085 - How can I add a rowversion column to a large ...
- 39
0
votes
1
answer
599
views
SQL Server 2022 trace flags
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 ...
- 827
0
votes
1
answer
505
views
Why does data file growth fail even with plenty of disk space?
We have a SQL Server 2016 (v13 SP3) Enterprise Edition server hosted in a Windows failover cluster / SQL Availability Group with two nodes (primary & secondary). The two nodes are running inside ...
- 756
1
vote
1
answer
1k
views
AG node getting "misaligned log IOs which required falling back to synchronous IO" events in error log
SQL 2016 AOAG. 3 node cluster. Primary and 1 secondary on-prem configured with synchronous availability mode. 1 node in Azure using asynchronous availability mode. We are using AOAGs to move data ...
- 11
0
votes
2
answers
2k
views
Automatically enable trace flag after server restart
We would like to permanently enable a trace flag on a server. I know that it is an option to add start-up parameters in SQL Server Configuration Manager. Is there any option to do it automatically ...
- 465
0
votes
2
answers
615
views
Sql Server Disk I/O Troughput In Performance monitor
i use sql server 2019 and trace flag 1117(Grow All Files in a FileGroup Equally) is on in my DataBase.
I need to consider the correct number of data files for primary file group according to my system ...
- 21
2
votes
1
answer
176
views
Why does SQL Server Trace Flag 715 behave differently from the TABLOCK query hint?
It's my understanding, based on numerous sources (including this one: https://techcommunity.microsoft.com/t5/sql-server/migrating-sap-workloads-to-sql-server-just-got-2-5x-faster/ba-p/384910) that SQL ...
- 177
4
votes
1
answer
284
views
Is Trace Flag 6534 Relevant Past SQL Server 2016?
Based on this link, I see that trace flag 6534 is relevant for SQL Server 2012 through 2016, but no mention of SQL Server 2017 or 2019. Is it still relevant for those editions or has it been folded ...
- 416
1
vote
2
answers
2k
views
seeding mode in SQL Server 2019
Does activating the TF9567 seeding mode trace flag speed up the synchronization process in AlwaysOn?
I am using SQL Server 2019.
0
votes
1
answer
368
views
Affinity side effects / TF 8002- how to measure
Environment: We have Microsoft SQL Server 2016 (SP2-CU15) Standard Edition (64-bit) on Windows Server 2016 Standard 10.0.
We have multiple SE instances on one physical server.
We use processor ...
- 1,268
13
votes
1
answer
629
views
Prevent THREADPOOL waits due to idle worker thread trimming
After reading Unusual THREADPOOL Waits by Josh Darnell, a Twitter user mentioned there is an undocumented trace flag to prevent trimming idle workers:
The idea is that once SQL Server has created ...
- 95.6k
0
votes
1
answer
2k
views
What is difference between starting Instance with -T3608 and with -f?
I simulated a corruption of model database on test environment just for learning purposes. While reading others blogs and articles about it I stuck on the question, what is difference between starting ...
- 1,283
0
votes
1
answer
227
views
SQL Server Lock Escalation clarity required
I want to know whether Enabling the Trace Flag 1211 globally prevents the Lock Escalation even in the event of the Huge Memory Pressure.
I have 2 Questions regarding this:-
After Enabling Trace Flag ...
