Press "Enter" to skip to content

Database-Level MAXDOP

Published 2016-10-07 by Kevin Feasel

Daniel Janik shows off setting Maximum Degree of Parallelism settings at the database level in SQL Server 2016:

The Maximum Degree of Parallelism (MAXDOP) can be defined in one of three ways:

  1. Instance Scoped via sp_configure
  2. Database Scoped via database properties
  3. Query Scoped via query option

Which of these trumps the other?

Click through for the answer.

Published in Administration