Grant, Thanks for the reply. Our Production SQL (prodSQL) is a SQL 2012 instance.
I agree. Don't make uninformed decisions. To that end, I've created an Extended Events session I called "CXPacketWaits".
I have 6 events in the session:
The filter for 2) is > 0
The filter for 5) & 6) is > 1
I ran the session for 2 hours today (12/9) during peak business hours. I'm going to run it again at peak hours tomorrow. I have an RFC open for tomorrow night to change the Cost Threshold for Parallelism from 50 to 500. I'm going to do two post-implementation EE sessions with the CXPacketWaits template. I hope to see a smaller degree_of_parallelism value. What other measures can you recommend for me to monitor?