Is this an intra-query parallelism deadlock and how to fix it?

I'm executing this procedure every 5 seconds and I am seeing a lot of deadlocks which I have not seen before. The query has not changed in over a year. I'm running SQL Server 2014 SP2 with 128GB ram, 32 processors and MAXDOP = 8. Trace Flags (1106,1117,1118,1204,1222,2371,2389,2390,2453,3023,4199)

Why am I seeing these deadlocks?

Are they intra-query parallelism deadlocks?

How can I fix them?

Thanks, Tony Green link text

avatar image By Tony Green 37 asked May 18 at 03:55 PM
more ▼
(comments are locked)
10|10000 characters needed characters left

0 answers: sort voted first
Be the first one to answer this question
toggle preview:

Up to 50 attachments (including images) can be used with a maximum of 209.7 MB each and 209.7 MB total.

Follow this question

Topics:

x14
x4
x1

asked: May 18 at 03:55 PM

Seen: 6 times

Last Updated: May 18 at 03:55 PM