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
By Tony Green 37 asked May 18, 2017 at 03:55 PM