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?