April 25, 2008 at 7:55 am
Got a problem with a job that fails occasionally with a deadlock.
I have enabled trave 1204 to give more details however it seems that the process was blocked by a system SPID and didnt give any more details that below.
Could somebody shed any more light on this? Thanks.
*********************************************
Date25/04/2008 01:28:34
LogSQL Server (Current - 25/04/2008 10:23:00)
Sourcespid5s
Message
ResType:ExchangeId Stype:'AND' SPID:69 BatchID:0 ECID:1 TaskProxy:(0x41EF7958) Value:0x8012cbd0 Cost:(N/A)
Date25/04/2008 01:28:34
LogSQL Server (Current - 25/04/2008 10:23:00)
Sourcespid5s
Message
ResType:ExchangeId Stype:'AND' SPID:69 BatchID:0 ECID:0 TaskProxy:(0x41EF6364) Value:0x8012ca38 Cost:(0/20003)
*********************************************
April 25, 2008 at 8:39 am
Is the job something you can change the isolation level on? Or change the sequence in which it locks resources?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 25, 2008 at 9:16 am
Have you tried running DBCC InputBuffer(blocking spid) to see what the blocking spid is doing?
Have you run sp_lock [blocked spid] to see what resources the job can't access?
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply