Run this DBCC SQL Trace

--DEADLOCKING TRACE FLAGS
-------------------------
--1204 Returns the type of lock participating in the deadlock and the current command affect by the deadlock.
--1205 Returns more detailed information about the command being executed at the time of a deadlock.
--1206 Used to complement flag 1204 by displaying other locks held by deadlock parties
--3605 Sends trace output to the error log. (If you start SQL Server from the command prompt, the output also appears on the screen.)

--Command to start trace
DBCC TRACEON (1204, 1205, 1206, 3605)

--Command to stop trace
DBCC TRACEOFF (1204, 1205, 1206, 3605)

--Command to see the status of a trace flag (1=ON, 0=OFF)
DBCC TRACESTATUS (1204, 1205, 1206, 3605)





-----Original Message-----
From: Craig Munday [Email address protected]
Sent: Thursday, 13 May 2004 6:35 p.m.
To: LazyDBA.com Discussion
Subject: How to diagnose deadlocks in SQL Server?


All,

Could someone point me in the direction of a paper that describes how to diagnose deadlocks within SQL Server?

Craig Munday
Software Development Manager
Giesecke & Devrient Australasia P/L, 32 Birnie Ave, Lidcombe 2141
Phone: +61 2 9646 6200 Fax: +61 2 9749 1678 [Email address protected] http://www.gdaus.com.au


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.673 / Virus Database: 435 - Release Date: 1/05/2004


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.673 / Virus Database: 435 - Release Date: 1/05/2004

----------

The information contained in this e-mail and any attachments is confidential
and is intended for the attention and use of the named addressee(s) only.
Any views expressed in this message are those of the individual sender and
may not necessarily reflect the views of Chelmer Limited.

MS Sql Server LazyDBA home page