Sql-server – Trace flag and which need to be turned off and Why

maintenanceperformancesql serversql-server-2008-r2trace

In SQL server there are so many trace flags. Why some of them need to be turned off. Some where i saw that trace flag 8017 need to be turned off. So i want to know which trace flag need to be tuned off and Why?

Best Answer

All should be turned off until you know why they should be implemented. Now if you inherit a server with a couple of trace flags on, do not just turn them off if you do not why they are there.

On a new server, knowledge first, then trace flag on. On a old server, leave as is, knowledge, make decision.