DBCC TRACEON (3605,1204,-1)

Hi

I am having deadlock issues and have been reading articals on ee as to how to trace my deadlocks.

I have seen the command DBCC TRACEON (3605,1204,-1), can anyone tell me what I do with this? I assume I paste into query analyser but how do I or indeed is there an output to reveiw?

Also do I need to switch it off again? in short and as only one question can someone tell me how to use this command?

Thanks
ac_davis2002Asked:
Who is Participating?
 
lundnakConnect With a Mentor Commented:
I have used the information from the following link to trace deadlocks.

http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/tracingdeadlocks/1324/
0
 
Eugene ZConnect With a Mentor Commented:
also you can  check

SQL Server technical bulletin  -  How to resolve a deadlock

http://support.microsoft.com/kb/832524

--
to disable you can use
DBCC TRACEOFF(-1)
more
http://msdn.microsoft.com/en-us/library/ms174401(SQL.90).aspx
0
 
ac_davis2002Author Commented:
thanks chaps
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.