Database ID not identified in deadlock alert

SQL Server performance monitoring and alerting

Moderators: eddie davis, priyasinha, Adam, chriskelly, Chris Lambrou, Chris Spencer

Database ID not identified in deadlock alert

Postby ginacresse » Thu Oct 13, 2011 11:56 pm

We get a lot of deadlock alerts that look like this:

Deadlocked processes: 139 139 139 139
Object blocked: Unknown

Deadlocked processes
SPID Victim Lock details Statement type
139
No Event:
Port: 0x00000000BA5BF650 Xid Slot: 13, Wait Slot: 5, Task: 0x000000034C499B88, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 INSERT Line #: 8823
139
No Event:
Port: 0x0000000382C8B500 Xid Slot: 13, Wait Slot: 5, Task: 0x000000034C4994C8, (Producer), Exchange Wait Type: e_waitPipeNewRow, Merging: 1 INSERT Line #: 8823
139
No Event:
Port: 0x00000004B6DF00F0 Xid Slot: 5, Wait Slot: 14, Task: 0x000000034C498508, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 INSERT Line #: 8823
139
No Event:
Port: 0x0000000A21867470 Xid Slot: 6, Wait Slot: 13, Task: 0x000000033DEE5948, (Consumer), Exchange Wait Type: e_waitPipeGetRow, Merging: 0 INSERT Line #: 8823

SQL query fragment:
No Event:


I don't see anything that identifies the database or object. Where can I find this information?
ginacresse
 
Posts: 6
Joined: Thu Oct 13, 2011 7:10 pm

Postby priyasinha » Fri Oct 14, 2011 9:37 am

Hi,

I am not a DBA but I think this deadlock is called "intra-query parallelism deadlocks". They occur between worker threads in a parallel query. They all show up with the same SPID.

You might find more information here.

Thanks,
Priya
priyasinha
 
Posts: 532
Joined: Wed Jan 03, 2007 5:02 pm


Return to SQL Monitor 2

Who is online

Users browsing this forum: No registered users and 0 guests