title: SQL Server 2000 - Debugging Deadlocks
body: <p>I'm looking for suggestions on how to debug and chase down deadlock issues in an SQL Server 2000 database.  I've had it recommended to me to use trace flags 1024 and 3605, which I have found give me the following:</p>
  
  <p>1024 - this trace flag returns the type of locks participating in the deadlock and the current command affected. </p>
  
  <p>3605 - this trace flag sends trace output to the error log.</p>
  
  <p>The specific stored procedures, tables and indexes still need to be uncovered, so the goal is to use these trace flags to do so.  And then from there I'll know better what indexes need tuning, locking hints for tuning queries, and potential sproc bugs to fix.</p>
  
  <p>Any other suggestions or happy ending war stories on chasing down this all to common problem?</p>