I am trying to analyze a dead lock trace.
I see this in the waitresource
waitresource=KEY: 9:72057594065256448 (ef008dce9cbe)
How can I find the exact key thats causing the problem? Thanks!
Look at the Trace Flag 1222 Example in SQL Server 2005 Books Online topic:
Detecting and Ending Deadlocks
http://msdn2.microsoft.com/en-us/library/ms178104.aspx
For example:
waitresource=KEY: 6:72057594057457664
dbid=6 objectname=AdventureWorks.dbo.T2
associatedObjectId=72057594057457664
keylock hobtid=72057594057457664
No comments:
Post a Comment