MAXDOP 1 requests serial execution for one SQL Server query. I measured four variants of one query on SQL Server 2025, and the serial plan was the slowest in elapsed time with about the same CPU. The post shows the settings behind the hint and how to read the degree of parallelism a query actually used.
Intra-Query Parallel Deadlock: When One Query Blocks Itself
No error, no deadlock graph, just a report that is slow on some runs. Here is a demo where one query deadlocks with itself, and how to fix it.
Setting MAXDOP and Cost Threshold Sensibly
MAXDOP and cost threshold work together to shape parallel plans; inspect current values, test a change, and watch real workload effects.
Finding Misconfigurations With One Script
Finding misconfigurations With One Script checks SQL Server settings that deserve a review, with recommendations tied to workload and evidence.
How Many CPUs SQL Server Really Uses
CPUs SQL Server really uses depend on edition, guest topology, affinity, and online schedulers; learn to see the instance’s usable capacity.
Standard Settings for a New SQL Server Install
Review standard settings for a new SQL Server install, including memory, MAXDOP, tempdb, backups, and alerts before users depend on it.