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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
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 RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply