August 15, 2011 at 2:20 pm
The deadlock info below was in the SQL Error Log as a result of having Trace Flag 1222 turned on.
Object ID 435584690 relates to a report proc, however in this info I am unable to determine anything about the other processes captured in the graph. Can anyone provide insight on how to read this info, or what else I should capture to get a better picture of what's going on when a deadlock like this occurs?
deadlock-list
deadlock victim=process33d8de28
process-list
process id=process85c2f8 taskpriority=0 logused=20015 waittime=359 schedulerid=1 kpid=7608 status=suspended spid=63 sbid=0 ecid=1 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process85ca78 taskpriority=0 logused=20032 waittime=234 schedulerid=1 kpid=7144 status=suspended spid=63 sbid=0 ecid=33 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process85cc58 taskpriority=0 logused=10035 schedulerid=1 kpid=6508 status=suspended spid=63 sbid=0 ecid=41 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process85cd48 taskpriority=0 logused=20017 waittime=359 schedulerid=1 kpid=5204 status=suspended spid=63 sbid=0 ecid=9 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process85da68 taskpriority=0 logused=20021 waittime=328 schedulerid=1 kpid=7080 status=suspended spid=63 sbid=0 ecid=17 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process85dc48 schedulerid=1 kpid=7920 status=running spid=63 sbid=0 ecid=50 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process85df18 taskpriority=0 logused=20029 waittime=234 schedulerid=1 kpid=2536 status=suspended spid=63 sbid=0 ecid=25 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process9f27a8 taskpriority=0 logused=20017 waittime=359 schedulerid=2 kpid=4520 status=suspended spid=63 sbid=0 ecid=16 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process9f2898 taskpriority=0 logused=20029 waittime=234 schedulerid=2 kpid=7936 status=suspended spid=63 sbid=0 ecid=31 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process9f2d48 schedulerid=2 kpid=7784 status=running spid=63 sbid=0 ecid=52 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process9f34c8 schedulerid=2 kpid=7404 status=runnable spid=63 sbid=0 ecid=48 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process9f3d38 taskpriority=0 logused=20032 waittime=234 schedulerid=2 kpid=7412 status=suspended spid=63 sbid=0 ecid=39 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process9f3f18 taskpriority=0 logused=20015 waittime=359 schedulerid=2 kpid=6504 status=suspended spid=63 sbid=0 ecid=2 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process335ea5c8 taskpriority=0 logused=20015 waittime=359 schedulerid=3 kpid=6044 status=suspended spid=63 sbid=0 ecid=3 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process335eaa78 taskpriority=0 logused=20032 waittime=234 schedulerid=3 kpid=6680 status=suspended spid=63 sbid=0 ecid=35 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process335eb018 schedulerid=3 kpid=7684 status=running spid=63 sbid=0 ecid=53 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process335eb3d8 schedulerid=3 kpid=6932 status=runnable spid=63 sbid=0 ecid=42 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process335ebb58 taskpriority=0 logused=20029 waittime=234 schedulerid=3 kpid=5472 status=suspended spid=63 sbid=0 ecid=26 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process335ebe28 taskpriority=0 logused=20021 waittime=328 schedulerid=3 kpid=7408 status=suspended spid=63 sbid=0 ecid=18 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process335ebf18 taskpriority=0 logused=20017 waittime=359 schedulerid=3 kpid=7824 status=suspended spid=63 sbid=0 ecid=11 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process336785c8 schedulerid=4 kpid=7604 status=runnable spid=63 sbid=0 ecid=43 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process336786b8 taskpriority=0 logused=20021 waittime=328 schedulerid=4 kpid=5416 status=suspended spid=63 sbid=0 ecid=24 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process33678a78 taskpriority=0 logused=20017 waittime=359 schedulerid=4 kpid=5816 status=suspended spid=63 sbid=0 ecid=10 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process33678b68 taskpriority=0 logused=20029 waittime=234 schedulerid=4 kpid=7924 status=suspended spid=63 sbid=0 ecid=32 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process33678f28 schedulerid=4 kpid=7916 status=running spid=63 sbid=0 ecid=56 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process33679a68 taskpriority=0 logused=20032 waittime=234 schedulerid=4 kpid=5220 status=suspended spid=63 sbid=0 ecid=34 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process33679c48 taskpriority=0 logused=20015 waittime=359 schedulerid=4 kpid=7724 status=suspended spid=63 sbid=0 ecid=4 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process33d8c2f8 taskpriority=0 logused=20021 waittime=328 schedulerid=5 kpid=6156 status=suspended spid=63 sbid=0 ecid=20 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process33d8c7a8 taskpriority=0 logused=20032 waittime=234 schedulerid=5 kpid=1408 status=suspended spid=63 sbid=0 ecid=37 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process33d8ca78 taskpriority=0 logused=20015 waittime=359 schedulerid=5 kpid=3376 status=suspended spid=63 sbid=0 ecid=8 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process33d8d2e8 waitresource=ACCESS_METHODS_SCAN_RANGE_GENERATOR (509221B8) schedulerid=5 kpid=7852 status=suspended spid=63 sbid=0 ecid=55 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process33d8d6a8 taskpriority=0 logused=20029 waittime=234 schedulerid=5 kpid=1216 status=suspended spid=63 sbid=0 ecid=28 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process33d8dd38 taskpriority=0 logused=20017 waittime=359 schedulerid=5 kpid=592 status=suspended spid=63 sbid=0 ecid=13 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process33d8de28 taskpriority=0 logused=10000 waittime=593 schedulerid=5 kpid=7984 status=suspended spid=63 sbid=0 ecid=0 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 loginname=US\karim.menoufy isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
Proc [Database Id = 6 Object Id = 435584690]
process id=process33d8df18 taskpriority=0 logused=10035 schedulerid=5 kpid=1856 status=suspended spid=63 sbid=0 ecid=44 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process33f22898 taskpriority=0 logused=20029 waittime=234 schedulerid=6 kpid=6564 status=suspended spid=63 sbid=0 ecid=27 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process33f22a78 schedulerid=6 kpid=7780 status=runnable spid=63 sbid=0 ecid=45 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process33f22f28 schedulerid=6 kpid=5424 status=running spid=63 sbid=0 ecid=54 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process33f23108 taskpriority=0 logused=20015 waittime=359 schedulerid=6 kpid=7496 status=suspended spid=63 sbid=0 ecid=5 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process33f232e8 taskpriority=0 logused=20021 waittime=328 schedulerid=6 kpid=6052 status=suspended spid=63 sbid=0 ecid=19 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process33f23b58 taskpriority=0 logused=20017 waittime=359 schedulerid=6 kpid=7812 status=suspended spid=63 sbid=0 ecid=12 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process33f23e28 taskpriority=0 logused=20032 waittime=234 schedulerid=6 kpid=8136 status=suspended spid=63 sbid=0 ecid=36 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process3443c6b8 schedulerid=7 kpid=7188 status=runnable spid=63 sbid=0 ecid=46 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process3443cf28 taskpriority=0 logused=20017 waittime=359 schedulerid=7 kpid=6824 status=suspended spid=63 sbid=0 ecid=14 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process3443d3d8 taskpriority=0 logused=20021 waittime=328 schedulerid=7 kpid=7104 status=suspended spid=63 sbid=0 ecid=22 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process3443d5b8 taskpriority=0 logused=20032 waittime=234 schedulerid=7 kpid=6740 status=suspended spid=63 sbid=0 ecid=38 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process3443d798 taskpriority=0 logused=20015 waittime=359 schedulerid=7 kpid=7560 status=suspended spid=63 sbid=0 ecid=7 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process3443d888 taskpriority=0 logused=20029 waittime=234 schedulerid=7 kpid=7700 status=suspended spid=63 sbid=0 ecid=30 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process3443db58 schedulerid=7 kpid=6480 status=running spid=63 sbid=0 ecid=51 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process600026b8 schedulerid=8 kpid=3440 status=running spid=63 sbid=0 ecid=49 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process600027a8 taskpriority=0 logused=20015 waittime=359 schedulerid=8 kpid=5164 status=suspended spid=63 sbid=0 ecid=6 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process60002f28 taskpriority=0 logused=20017 waittime=359 schedulerid=8 kpid=7376 status=suspended spid=63 sbid=0 ecid=15 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process600034c8 schedulerid=8 kpid=2580 status=runnable spid=63 sbid=0 ecid=47 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process600035b8 taskpriority=0 logused=20032 waittime=234 schedulerid=8 kpid=7156 status=suspended spid=63 sbid=0 ecid=40 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process60003798 taskpriority=0 logused=20021 waittime=328 schedulerid=8 kpid=4604 status=suspended spid=63 sbid=0 ecid=21 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
process id=process60003e28 taskpriority=0 logused=20029 waittime=234 schedulerid=8 kpid=7092 status=suspended spid=63 sbid=0 ecid=29 priority=0 transcount=0 lastbatchstarted=2011-08-12T12:54:47.363 lastbatchcompleted=2011-08-12T12:54:47.363 clientapp=.Net SqlClient Data Provider hostname=K0719SIM hostpid=11504 isolationlevel=read committed (2) xactid=126781425 currentdb=6 lockTimeout=4294967295 clientoption1=536870944 clientoption2=128056
executionStack
frame procname=unknown line=43 stmtstart=2768 sqlhandle=0x03000600b27ef619d898f9000c9900000100000000000000
unknown
inputbuf
resource-list
threadpool id=scheduler33780040
owner-list
owner id=process33679c48
owner id=process33679a68
owner id=process33678b68
owner id=process33678a78
owner id=process336786b8
owner id=process336785c8
waiter-list
waiter id=process33678f28
exchangeEvent id=port3e3c500 nodeId=35
owner-list
owner event=e_waitNone type=producer id=process33d8d2e8
owner event=e_waitNone type=producer id=process33678f28
waiter-list
waiter event=e_waitNone type=consumer id=process335eb3d8
waiter event=e_waitNone type=consumer id=process85cc58
waiter event=e_waitNone type=consumer id=process336785c8
waiter event=e_waitNone type=consumer id=process33d8df18
waiter event=e_waitNone type=consumer id=process600034c8
waiter event=e_waitNone type=consumer id=process33f22a78
waiter event=e_waitNone type=consumer id=process9f34c8
waiter event=e_waitNone type=consumer id=process3443c6b8
waiter event=e_waitNone type=producer id=process600026b8
waiter event=e_waitNone type=producer id=process85dc48
waiter event=e_waitNone type=producer id=process3443db58
waiter event=e_waitNone type=producer id=process9f2d48
waiter event=e_waitNone type=producer id=process335eb018
waiter event=e_waitNone type=producer id=process33f22f28
threadpool id=scheduler33e10040
owner-list
owner id=process33d8df18
owner id=process33d8de28
owner id=process33d8dd38
owner id=process33d8d6a8
owner id=process33d8ca78
owner id=process33d8c7a8
owner id=process33d8c2f8
waiter-list
waiter id=process33d8d2e8
exchangeEvent id=port3e3c380 nodeId=32
owner-list
owner event=e_waitNone type=producer id=process335eb3d8
waiter-list
waiter event=e_waitPortOpen type=consumer id=process335eaa78
waiter event=e_waitPortOpen type=consumer id=process33679a68
waiter event=e_waitPortOpen type=consumer id=process85ca78
waiter event=e_waitPortOpen type=consumer id=process33f23e28
waiter event=e_waitPortOpen type=consumer id=process33d8c7a8
waiter event=e_waitPortOpen type=consumer id=process9f3d38
waiter event=e_waitPortOpen type=consumer id=process3443d5b8
waiter event=e_waitPortOpen type=consumer id=process600035b8
exchangeEvent id=port3e3ca00 nodeId=29
owner-list
owner event=e_waitNone type=producer id=process335eaa78
waiter-list
waiter event=e_waitPortOpen type=consumer id=process33d8d6a8
waiter event=e_waitPortOpen type=consumer id=process9f2898
waiter event=e_waitPortOpen type=consumer id=process60003e28
waiter event=e_waitPortOpen type=consumer id=process3443d888
waiter event=e_waitPortOpen type=consumer id=process33f22898
waiter event=e_waitPortOpen type=consumer id=process85df18
waiter event=e_waitPortOpen type=consumer id=process33678b68
waiter event=e_waitPortOpen type=consumer id=process335ebb58
exchangeEvent id=port3e3c880 nodeId=21
owner-list
owner event=e_waitNone type=producer id=process335ebb58
waiter-list
waiter event=e_waitPortOpen type=consumer id=process336786b8
waiter event=e_waitPortOpen type=consumer id=process3443d3d8
waiter event=e_waitPortOpen type=consumer id=process335ebe28
waiter event=e_waitPortOpen type=consumer id=process33d8c2f8
waiter event=e_waitPortOpen type=consumer id=process60003798
waiter event=e_waitPortOpen type=consumer id=process33f232e8
waiter event=e_waitPortOpen type=consumer id=process85da68
exchangeEvent id=port3e3cb00 nodeId=17
owner-list
owner event=e_waitNone type=producer id=process335ebe28
waiter-list
waiter event=e_waitPortOpen type=consumer id=process33678a78
waiter event=e_waitPortOpen type=consumer id=process335ebf18
waiter event=e_waitPortOpen type=consumer id=process33f23b58
waiter event=e_waitPortOpen type=consumer id=process33d8dd38
waiter event=e_waitPortOpen type=consumer id=process85cd48
waiter event=e_waitPortOpen type=consumer id=process9f27a8
waiter event=e_waitPortOpen type=consumer id=process3443cf28
waiter event=e_waitPortOpen type=consumer id=process60002f28
exchangeEvent id=port3e3cd80 nodeId=15
owner-list
owner event=e_waitNone type=producer id=process33678a78
waiter-list
waiter event=e_waitPortOpen type=consumer id=process33679c48
waiter event=e_waitPortOpen type=consumer id=process33d8ca78
waiter event=e_waitPortOpen type=consumer id=process9f3f18
waiter event=e_waitPortOpen type=consumer id=process335ea5c8
waiter event=e_waitPortOpen type=consumer id=process85c2f8
waiter event=e_waitPortOpen type=consumer id=process3443d798
waiter event=e_waitPortOpen type=consumer id=process600027a8
waiter event=e_waitPortOpen type=consumer id=process33f23108
exchangeEvent id=port3e3c800 nodeId=0
owner-list
owner event=e_waitNone type=producer id=process33f23108
waiter-list
waiter event=e_waitPortOpen type=consumer id=process33d8de28
Some particulars:
BuildClrVersionv2.0.50727
CollationSQL_Latin1_General_CP1_CI_AS
ComparisonStyle196609
EditionStandard Edition
EditionID-1534726760
EditionIDDescriptionSTANDARD
EngineEdition2
EngineEditionDescriptionStandard
IsClustered0
IsFullTextInstalled1
IsIntegratedSecurityOnly0
IsSingleUser0
LCID1033
ProductVersion9.00.4060.00
ProductLevelSP3
SqlCharSet1
SqlCharSetNameiso_1
SqlSortOrder52
SqlSortOrderNamenocase_iso
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
August 15, 2011 at 3:38 pm
There's only info on one process because there's only one process involved in that deadlock. Look through the deadlock graph, the spid is 63 on every single one.
What this is is an intra-query parallelism deadlock. It's actually a bug in SQL, they shouldn't be able to happen (basically the various parallel threads of one spid are blocking each other)
You can try patching SQL to SP 4, you can also try MAXDOP hints on that query.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 15, 2011 at 4:14 pm
Yikes! I read where running an additional trace, to cast a wider net, was sometimes necessary to see what other SQL was participating in a deadlock. I was most certainly game for that. I was not expecting to find out that I had run into a bug.
Now to decide...upgrade to SP4 now or continue to work towards the 2008R2-migration set for later this year :unsure:
Discussing that topic with the team will be a great way to start off the day tomorrow. Thanks as always Gail 🙂
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
August 15, 2011 at 4:22 pm
Always a pleasure. 😀
There is a workaround - OPTION (MAXDOP n) on that query where n is some number less than the cores you have (drop it until it deadlocks no more). Tuning the query may also help.
btw, that's not the first of those I've seen today, is why I recognised it. Found one in a client's error log while evaluating their deadlock problem. Also found a 27 node conventional deadlock.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 15, 2011 at 5:43 pm
It must be in the water or something...it's funny how somewhat rare items tend to surface in bunches on these forums. I turned on 1222 last week and have had 7 graphs captured since then...none of which reference multiple spids and 3 of which have 0 references to objects nor any SQL text! In those 3 they all have "unknown" in all instances the inputbuf and procname values. I have no evidence or experience to lean on but it seems unlikely that I would hit an intra-query parallelism bug on 7 out of 7 deadlock graphs in a 5 day period...this has proven to be a strange environment though and I have to concede that anything is possible.
Adding the MAXDOP hint may be a doable option for the one I posted. Thanks for that 🙂 Changing the query is likely out of the question. It's practically an Act of Congress (U.S. so you can imagine) to get basic things to production here. I am still watching for some scripts I wrote weeks ago containing a few simple UPDATE STATISTICS commands to make it through. I am having to educate management, step by agonizing step, about what statistics really are, and how updating them should not need to go through QA.
I read a post on SSC earlier today, which of course I cannot find now, that talked about the spid in the graph possibly being the deadlock monitoring spid, not the spids actually involved in the deadlock, so they should all be the same, but that seems wrong and counter to what the graph should be providing. I may have read the post wrong...this is my first real deep dive into these graphs. All the graphs I have dealt with before now (< 5) were simple to read and were easy to correct with either a change in the order of operations in a proc or an indexing tweak.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
August 16, 2011 at 3:40 am
opc.three (8/15/2011)
I read a post on SSC earlier today, which of course I cannot find now, that talked about the spid in the graph possibly being the deadlock monitoring spid, not the spids actually involved in the deadlock, so they should all be the same,
The SPID producing the graph will all be the same - that'll be the second column in the error log that says something like spid18s, but the spids referenced within the deadlock (schedulerid=1 kpid=7144 status=suspended spid=63 sbid=0 ecid=33) those are the spids involved in the deadlock.
Adding a maxdop hint to the query will require changing the query. I'm not suggesting changing the server-wide max dop for one query.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 16, 2011 at 7:42 am
GilaMonster (8/16/2011)
opc.three (8/15/2011)
I read a post on SSC earlier today, which of course I cannot find now, that talked about the spid in the graph possibly being the deadlock monitoring spid, not the spids actually involved in the deadlock, so they should all be the same,The SPID producing the graph will all be the same - that'll be the second column in the error log that says something like spid18s, but the spids referenced within the deadlock (schedulerid=1 kpid=7144 status=suspended spid=63 sbid=0 ecid=33) those are the spids involved in the deadlock.
Thanks for the clarification. That confirms how I was reading and thinking about the graph. I never factored the ProcessInfo column into the equation. As I understand the trace and error log it is only natural for the ProcessInfo column to be the same for all error log entries since all entries are from a single deadlock graph. It's just that they look like they are separate entries either because of how they are retrieved or how they are stored in the error log itself.
Adding a maxdop hint to the query will require changing the query. I'm not suggesting changing the server-wide max dop for one query.
Yes on adding a query HINT. No on changing the server configuration. When I said "changing the query is likely out of the question" I meant that towards only adding the hint and not changing the logic. I am going to look at the plan for the query as well to see if an indexing change would help. If I only add a hint or tweak some indexing then I can likely ease the QA-burden. In any case, index and/or query hint, this one will go on the watch-list for when SP4 or 2008R2 happens. Even with this information in hand, them deciding on doing nothing is also on the table at this place 🙂
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
August 16, 2011 at 7:46 am
p.s. If you want some more info on reading deadlock graphs, Chapter 42 of SQL Server MVP Deep Dives is on that topic </blatant self-promotion>
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
August 16, 2011 at 10:31 am
GilaMonster (8/16/2011)
</blatant self-promotion>
Blatant! I love it 😀
Impressive TOC...Chapter 42 alone is worth the coin 😉
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply