SQL Server Wait Types - Professional SQL Server 2005 Performance Tuning - page 87

A deadlock output looks like this:
deadlock-list
deadlock victim=process988f28
process-list
process id=process988b68 taskpriority=0 logused=236 waitresource=PAGE: 9:1:110
waittime=4718 ownerId=6233 transactionname=user_transaction lasttranstarted=2007-09-
03T23:14:56.530 XDES=0x58a07f0 lockMode=S schedulerid=2 kpid=4212 status=suspended
spid=54 sbid=0 ecid=0 priority=0 transcount=1 lastbatchstarted=2007-09-03T23:15:39.
530 lastbatchcompleted=2007-09-03T23:14:56.530 lastattention=2007-09-03T22:54:53.497
clientapp=Microsoft SQL Server Management Studio - Query hostname=STUDYPC host-
pid=5312 loginname=STUDYPC \ Christian isolationlevel=read committed (2) xactid=6233
currentdb=9 lockTimeout=4294967295 clientoption1=671090784 clientoption2=390200
executionStack
frame procname=adhoc line=1 stmtstart=36
sqlhandle=0x02000000978fb129ee9e7073d169972d3459d9183f365a2b
SELECT * FROM [people] WHERE [personid]=@1
frame procname=adhoc line=1
sqlhandle=0x02000000bc719c0327c935dde5ab234e257b5956e3670e69
SELECT * FROM people
WHERE personid = '63E3D4B0-8155-DC11-9676-00138F9F2378'
inputbuf
SELECT * FROM people
WHERE personid = '63E3D4B0-8155-DC11-9676-00138F9F2378'
process id=process988f28 taskpriority=0 logused=216 waitresource=RID: 9:1:109:12
waittime=15109 ownerId=5438 transactionname=user_transaction lasttranstarted=2007-
09-03T23:11:30.483 XDES=0x58a0250 lockMode=S schedulerid=2 kpid=2504 status=suspended
spid=53 sbid=0 ecid=0 priority=0 transcount=1 lastbatchstarted=2007-09-03T23:
15:29.153 lastbatchcompleted=2007-09-03T23:11:30.497 clientapp=Microsoft SQL Server
Management Studio - Query hostname=STUDYPC hostpid=5312 loginname=STUDYPC \ Christian
isolationlevel=read committed (2) xactid=5438 currentdb=9 lockTimeout=4294967295
clientoption1=671090784 clientoption2=390200
executionStack
frame procname=adhoc line=1 stmtstart=36
sqlhandle=0x0200000033c24915c37a771dd564c5d67e9332074c7f9fe9
SELECT * FROM [lastnames] WHERE [name]=@1
frame procname=adhoc line=1
sqlhandle=0x0200000078b28408ba6b06d21cbf6fadedf220ceffbb6c4d
SELECT * FROM lastnames
WHERE name = 'EKGLIMGIJYALXAYC'
inputbuf
SELECT * FROM lastnames
WHERE name = 'EKGLIMGIJYALXAYC'
resource-list
ridlock fileid=1 pageid=109 dbid=9
objectname= people.dbo.lastnames id=lock3ca4f40 mode=X
associatedObjectId=72057594041663488
owner-list
owner id=process988b68 mode=X