SQL Server Performance

Deadlock on DatabaseID 0

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by LanLan, Nov 8, 2006.

  1. LanLan New Member

    My SQL Profiler catches a couple of Lock<img src='/community/emoticons/emotion-2.gif' alt=':D' />eadlock Chain event. The weird thing is that the DatabaseID is 0, the SPID is 4 which indicates LOCK MONITOR. How to interpret it? The SQL Profiler is SQL 2005, the targeted server is SQL2000 Enterprise.<br /><br />
  2. gurucb New Member

    I would say better in sql server 2000 enable trace flag 1204,1205 and then repro the problem. In error log you will see dead lock graph and that can be analyzed. SQL server 2005 profiler also has capability of showing graphically as well but for that xml events needs to be raised which SQL Server 2005 can.

Share This Page