I've got to ask a follow up question. I am not certain when I should execute the
DBCC TRACEON(3604)
DBCC TRACEON(1294)
commands. For example, I've got a situation in which a deadlock occurs, but maybe only once every three or four weeks. Do I just go into Query Analyzer, execute those commands now, and wait a few weeks until the problem shows up? Or do I only execute those commands while the deadlock is in process?
Doctor Who