[dba-SQLServer] Trace Deadlocks Using DBCC TRACEON (1204)

Paul Hartland paul.hartland at googlemail.com
Wed Oct 15 02:50:02 CDT 2008


To all,

We have started getting a couple of deadlocking issues every now and again,
I have read that you can turn on a trace using

DBCC TRACEON (1204)
Can anyone tell me, where this command will put the results in a case of a
deadlock being raised.  Or has anyone any better ideas, of how I can find
out the queries/views/SP's that are causing the deadlocks please.

I have told each of our staff to report to me immediately if they get a
deadlock issue, so then I want to look at a report or log to attempt to find
out what is going on.

Thanks in advance for any help on this.


-- 
Paul Hartland
paul.hartland at googlemail.com



More information about the dba-SQLServer mailing list