The Maximum Degree of Parallelism (MAXDOP) can be defined in one of three ways:
- Instance Scoped via sp_configure
- Database Scoped via database properties
- Query Scoped via query option
Which of these trumps the other?
Click through for the answer.
A Fine Slice Of SQL Server
The Maximum Degree of Parallelism (MAXDOP) can be defined in one of three ways:
- Instance Scoped via sp_configure
- Database Scoped via database properties
- Query Scoped via query option
Which of these trumps the other?
Click through for the answer.