New answers tagged parallelism
In addition to reading the links provided above and most likely changing your "Max Degree of Parallelism" setting from 0 to something like 8, you'll want to narrow down which of your queries are going parallel and what their cost is. After seeing the impact of this change you can also consider modifying your "Cost Threshold for Parallelism" to fine tune ...
Read Diagnosing and Resolving Latch Contention on SQL Server, is the most comprehensive paper on the topic. You'll have to dig into sys.dm_os_latch_stats and see what latch type is the contention on. See if reading How to analyse SQL Server performance helps you in any way.
Top 50 recent answers are included