We are using SQL Server 2000. In production we are facing deadlock problems. If we try to run a trace then users starts complaining that there are not able to get into the application. What do you think are the options that we have to trace down deadlock issues? We have hundreds of stored procedures, triggers. So, we do not know from where it is coming and why? If we use the flags: DBCC TRACEON (3604) DBCC TRACEON (1204 Will that impact performance of SQL Server 2000? Is using flags same As using trace in profiler. I would really appreciate your help.