-
Monitoring Deadlocking using profiler
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|