Where can I find documentation that explains all the cryptic information returned in the SQL Server logs when a deadlock occurs? I've read several articles that describe some of the items, but I'm trying to find the definitive docs understanding deadlock-list log information and how to use the information when diagnosing the problem.
For example, what do these entries represent and how do I use them to understand the problem?:
- waitresource=PAGE:10:1:1734
- ownerid=30963222
- XDEX=0x41a1855
- lockmode=S
- kpid=11284
- fileid=1
- pageid=1734
- id=lock433ed580
- mode=IX
- ExchangeEvent id=port423454333
Thanks