More CPU cores may not always lead to better performance – MAXDOP and query memory distribution in spotlight
- by sqlworkshops
More hardware normally delivers better performance, but there are exceptions where it can hinder performance. Understanding these exceptions and working around it is a major part of SQL Server performance tuning.
When a memory allocating query executes in parallel, SQL Server distributes memory to each task that is executing part of the…