Cost threshold for parallelism and wait stats
SOS_SCHEDULER_YIELD and CXPACKET indicates that you’ve got contention and that queries are spending a lot of time waiting to get access to a CPU.
Check MAXDOP and Cost Threshold for Parallelism to determine when the query should be parallelized.