Deadlocks in the error log

It seems that the information written to the error log about deadlocks
changed in 2005 and I can no longer tell what the numbers mean. Like
for instance, the information after KEY? I can't seem to find sql
server 2005 documentation on this. Can anyone point me to it?
Node:1
KEY: 8:72057594060537856 (9a03c330cb9d) CleanCnt:4 Mode:S Flags: 0x0
Wait List:
Owner:0x000000016A300880 Mode: X Flg:0x2 Ref:1 Life:02000000
SPID:90 ECID:0 XactLockInfo: 0x00000000C69213F8
SPID: 90 ECID: 0 Statement Type: UPDATE Line #: 805
Input Buf: RPC Event: Proc [Database Id = 8 Object Id = 1535500699]
Requested By:
ResType:LockOwner Stype:'OR'Xdes:0x000000015E8F5AD0 Mode: S SPID:91
BatchID:0 ECID:0 TaskProxy0x0000000169426598) Value:0x8011fbc0 Cost5/0)
NULL
Node:2
KEY: 8:72057594060537856 (9a03c330cb9d) CleanCnt:4 Mode:S Flags: 0x0
Grant List 0:
Owner:0x00000000851FAF80 Mode: S Flg:0x0 Ref:0 Life:00000001
SPID:84 ECID:0 XactLockInfo: 0x00000000D431A3A8
SPID: 84 ECID: 0 Statement Type: INSERT Line #: 424
Input Buf: RPC Event: Proc [Database Id = 8 Object Id = 1052739003]
Grant List 3:
Requested By:
ResType:LockOwner Stype:'OR'Xdes:0x00000000C69213C0 Mode: X SPID:90
BatchID:0 ECID:0 TaskProxy0x00000000BE4D8598) Value:0x6a300880
Cost5/8728)
NULL
Node:3
KEY: 8:72057594059882496 (b000142fd0ae) CleanCnt:3 Mode:X Flags: 0x0
Wait List:
Owner:0x0000000100247C00 Mode: S Flg:0x2 Ref:1 Life:00000000
SPID:89 ECID:0 XactLockInfo: 0x0000000123AE8738
SPID: 89 ECID: 0 Statement Type: INSERT Line #: 424
Input Buf: RPC Event: Proc [Database Id = 8 Object Id = 1052739003]
Requested By:
ResType:LockOwner Stype:'OR'Xdes:0x00000000D431A370 Mode: S SPID:84
BatchID:0 ECID:0 TaskProxy0x00000000B7D8C598) Value:0x2a74e200 Cost5/0)
NULL
Node:4
KEY: 8:72057594059882496 (b000142fd0ae) CleanCnt:3 Mode:X Flags: 0x0
Grant List 1:
Owner:0x00000000801A62C0 Mode: X Flg:0x0 Ref:0 Life:02000000
SPID:90 ECID:0 XactLockInfo: 0x00000000C69213F8
Requested By:
ResType:LockOwner Stype:'OR'Xdes:0x0000000123AE8700 Mode: S SPID:89
BatchID:0 ECID:0 TaskProxy0x00000000AAE48598) Value:0x247c00 Cost5/0)
NULL
Victim Resource Owner:
ResType:LockOwner Stype:'OR'Xdes:0x0000000123AE8700 Mode: S SPID:89
BatchID:0 ECID:0 TaskProxy0x00000000AAE48598) Value:0x247c00 Cost5/0)
Deadlock encountered ... Printing deadlock information
Wait-for graph
NULLHi, Frank,
Thanks for your post.
From your description, I understand that you would like to know what the
KEY means in SQL error logs.
If I have misunderstood, please let me know.
KEY Identifies the key range within an index on which a lock is held or
requested. KEY is represented as KEY: db_id:hobt_id (index key hash value).
For example, KEY: 6:72057594057457664 (350007a4d329).
For more information, you can refer to:
Detecting and Ending Deadlocks
http://msdn2.microsoft.com/en-us/library/ms178104.aspx
If you have any other questions or concerns, please feel free to let me
know.
Have a good day!
Best regards,
Charles Wang
Microsoft Online Community Support
========================================
=============
Get notification to my posts through email? Please refer to:
http://msdn.microsoft.com/subscript...ault.aspx#notif
ications
If you are using Outlook Express, please make sure you clear the check box
"Tools/Options/Read: Get 300 headers at a time" to see your reply promptly.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscript...t/default.aspx.
========================================
==============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============|||Hi,
I am interested in this issue. Would you mind letting me know the result of
the suggestions? If you need further assistance, feel free to let me know.
I will be more than happy to be of assistance.
Charles Wang
Microsoft Online Community Support
========================================
==============
When responding to posts, please "Reply to Group" via
your newsreader so that others may learn and benefit
from this issue.
========================================
==============
This posting is provided "AS IS" with no warranties, and confers no rights.
========================================
==============