SQL 2000: trace for dead lock

-- http://www.sql-server-performance.com/rd_traceflags.asp
-- http://www.sql-server-performance.com/ac_2000_trace_flags.asp
-- http://www.mssqlcity.com/Articles/General/SQL2000TF.htm

-- This trace flag returns the type of locks participating
-- in a deadlock and the current command affected. This trace
-- flag was documented in the SQL Server 7.0 Books Online, 
-- but not documented in the SQL Server 2000 Books Online.

DBCC TRACESTATUS(1204)

-- This trace flag returns more detailed information about 
-- the command being executed at the time of a deadlock. This 
-- trace flag was documented in the SQL Server 7.0 Books 
-- Online, but not documented in SQL Server 2000 Books Online.

DBCC TRACESTATUS(1205)

-- In comparison with Trace flag 3604, this trace flag sends
-- trace output to the error log. Trace flag 3605 was documented 
-- in SQL Server 6.5 Books Online and in SQL Server 7.0 Books 
-- Online, but was not documented in SQL Server 2000

DBCC TRACESTATUS(3605)

 

DBCC TRACEON(3605, 1204)
DBCC TRACEON(1205)

DBCC TRACEOFF(3605, 1204)
DBCC TRACEOFF(1205)
Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s