• 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