What would be the optimal way to decrease Parallel Operators?
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%!