What are the risks/caveats of modifying the maximum degree of parallelism? We've just upgraded some hardware and there are some queries that actually got slower. I am thinking about setting the maximum degree of parallelism to 1 as this is an OLTP system. How impactful is it to toggle back-n-forth to view the impact? Please just consider the variables provided. Suggesting others is fine.
I'm hoping someone with experience with this provides some feedback.