What would be the optimal way to decrease Parallel Operators?

vfrank66 2017-02-18 14:41:51

My production environment has this query which takes our Production environment to 100% for several minutes. This seems to be the query at the time. I could set the MAXDOP which would satify the CPU but then I worry about a huge decrease in performance. Unfortunetly I don't know to test MAXDOP in sql. I could test in an environment with same data in SQL but again I don't know how to.

I need to help reduce this query from causing CPU to 100%!

Aaron Bertrand 2017-02-22 21:24:58
Well, you anonymized an estimated plan using an old version of Plan Explorer. Can you please update to Plan Explorer 11.0.84, generate an actual plan for this query from inside of Plan Explorer, and post the results of that (preferably non-anonymized)?