thanks for the help. So turning the trace files on will not have any impact on performance.
I read some where that it may slow down database.
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...
Separate names with a comma.