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

Tony Green 2017-05-18 15:55:20

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?

Tony Green
link text