July 25, 2018 at 10:29 am
So I know this is going to be a loaded question, but just wanted to see what Trace Flags others are enabling on SQL 2014 servers.
We have a few servers that hold about 100 OLTP databases each. Performance is not bad, but think it could be better.
I reviewed all the Trace Flags, but am looking to see what other have applied in the start up parameters.
Currently we have the following trace flags enabled:
T1117
T1118
T1204
T3226
T4199
Thank you!!!
July 26, 2018 at 7:31 am
I honestly hate trace flag discussions.
However, I'd suggest adding 2371 to the list.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
July 26, 2018 at 7:32 am
Oh, and, you're on 2014. The system_health extended events session captures deadlocks. You don't need 1204. It's just going to dirty up your logs.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply