SQL Job - Deadlock

  • 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)

    *********************************************

  • 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

  • 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?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply