06-08-06, 18:32 #1Registered User
- Join Date
- Jun 2006
Unanswered: How to interpret the profiler trace
Thanks in advance for your help. Any help is appreciated.
I have a urgent production deadlock issue. Because of the deadlock, one of the import applications is killed by SQL Server.
I tried to find out the reason of deadlock. I run the SQL Profiler and I use the following eventclass:
Exec Prepared SQL
In the trace log file, I can only found a line under "Lockeadlock" eventclass, if I highlight that line, I saw the following two words:
I can't find anything under "Lockeadlock Chain" eventclass which is weird.
Here is the info from that line:
StartTime: 2006-06-06 13:01:12.053
EndTime: 2006-06-06 13:01:14.100