[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1773
  • Last Modified:

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
0
ac_davis2002
Asked:
ac_davis2002
2 Solutions
 
lundnakCommented:
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 ZCommented:
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now