DBCC TRACE FLAG best practices

Question

DBCC TRACE FLAG best practices

SQlLogic

SSCrazy Eights

Points: 9686
More actions
February 22, 2012 at 12:51 pm

#257257

HI folks
like to know -IS it Good to keep Trace Flag 1204 , 1205 on all the time in production Environment?
Does it affect on performance?
Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

I wouldn't use either on a SQL 2008 server. On SQL 2008 for deadlocks either check the system health session (extended events) or use traceflag 1222

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

SQlLogic SSCrazy Eights Points: 9686 More actions · Answer 2

found nice article and tool here

http://www.mssqltips.com/sqlservertip/2369/using-extended-events-to-troubleshoot-sql-server-issues/

thanks for kind guidance...