views:

110

answers:

2

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

+1  A: 

This might be a good start: Interpreting deadlock trace output in SQL Server

Frank Kalis