Max degree of parallelism: it caps how many processors one query may use, and can be set for the server, as a database scoped configuration or as a query hint.
Also called max degree of parallelism.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains MAXDOP in context, with comparison tables and the common traps.
Terms in this definition
- Set
Secret permission in Key Vault for writing secrets; some older material refers to it as Create.
- Database scoped configuration
Per-database options, for example MAXDOP, IDENTITY_CACHE and scalar UDF inlining, that are set on an individual database instead of server-wide; a secondary replica can be given its own value.
Related terms
- OPTION clause
Placed last in a statement, this clause carries query hints, for instance RECOMPILE, MAXDOP 1 or HASH JOIN, which then govern every operator in that statement.
- Query Store hints
A way to change how a query behaves, with hints such as RECOMPILE or MAXDOP tied to its query_id, while its code stays untouched. Supported from SQL Server 2022, in Azure SQL and in Fabric.