Red Gate forums :: View topic - Database ID not identified in deadlock alert
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Monitor 2
SQL Monitor 2 forum

Database ID not identified in deadlock alert

Search in SQL Monitor 2 forum
Post new topic   Reply to topic
Jump to:  
Author Message
ginacresse



Joined: 13 Oct 2011
Posts: 6

PostPosted: Thu Oct 13, 2011 11:56 pm    Post subject: Database ID not identified in deadlock alert Reply with quote

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?
Back to top
View user's profile Send private message
priyasinha



Joined: 03 Jan 2007
Posts: 531

PostPosted: Fri Oct 14, 2011 9:37 am    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group