The default value for cost threshold for parallelism is 5. I have read numerous blog post and attended different SQL Server related training sessions where really smart people have all said this value is 'way to low' on modern hardware. That the default value was carried over from the SQL Server 7 days. It is recommended by many that this value be increased. Asking around some have said start with 20, answers by others have ranged from 20 - 250. All seem to be in agreement that 5 is to low. I am curious if others have found a sweet spot as the standard new default for their organization and how you came to chose that number. Was it just a swag, based on a blog you read or a number based on analysis you conducted.
The sweetspot I found was at 35. It seemed to be big enough without being too big for most of the OLTP systems I've had under management. Sometimes, depending on the system, I might go up from there, but so far, I've never gone down.