Database-Level MAXDOP

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.

Related Posts

Storage Forecasting In SentryOne

Steven Wright shows off a neat feature in the SentryOne product: With that in mind, SentryOne has been working toward integrating advanced predictive analytics into our products. SentryOne 18.5 includes the first feature set to make use of advanced analytics and machine learning technology—introducing advanced Storage Forecasting. In its most advanced configuration, SentryOne now applies machine […]

Read More

Creating A SQL Server 2019 Big Data Cluster On Azure

Niels Berglund walks us through the setup for SQL Server 2019 Big Data Clusters: If you, like me, are a SQL Server guy, you are probably quite familiar with installing SQL Server instances by mounting an ISO file, and running setup. Well, you can forget all that when you deploy a SQL Server 2019 Big Data […]

Read More

Categories

October 2016
MTWTFSS
« Sep Nov »
 12
3456789
10111213141516
17181920212223
24252627282930
31