Chad Callihan covers cost threshold for parallelism:
Let’s talk about cost threshold for parallelism. This is one of the main deciders in a query going parallel. Do you know what it’s set to on your databases?
Read on to learn more and get Chad’s crowd-sourced recommendation for a proper value.