Deadlock on DatabaseID 0 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Deadlock on DatabaseID 0

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 />
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.