SQL SERVER – MAXDOP Settings to Limit Query to Run on Specific CPU

The MAXDOP query hint limits how many CPUs a query can use, though not which ones. With OPTION (MAXDOP 1), the parallelism operator leaves the plan.