Execution plan that does not show parrallelism but comes from intra-query deadlock graph

wsmelton 2014-10-31 16:26:47

Environment: SQL Server 2012 (11.0.3412), 2 processors, 16GB RAM, MAXDOP=0 for the instance.

I pulled the deadlock graph on a server to find one that indicated intra-query deadlock (all processes have the same SPID). I took the sql_handle shown for the first process and pulled the execution plan in cache (possible plan may have changed already but kind of doubt that).

The procedure that the deadlock comes from is convoluted. It is dynamic query built and executed via sp_executesql. The statement in the execution plan is the executed statement.

So my question is if the deadlock for this statement shows an intra-query deadlock can that happen when the plan does not indicate any parallel operators?

Deadlock XML Report

Jonathan Kehayias 2014-10-31 17:54:19
Can you post the deadlock graph as well?