Hi guys,
I've been monitoring Deadlocking on my live server, because I think I have a performance problem on a table.
When the deadlock occurs I have managed to capture it using sql profiler.
Sql profiler then hangs and users cannot use the database server or application.
The nt event log shows sql profiler problem.
I am concerned that profiler could contribute to the problem, especially when
when you have a deadlocking problem.
Does anyone have experience of this. Are there any performance issues to be aware of when using profile