Configure MAXDOP (max degree of parallelism) on SQL Server 2016… 2019)

The Microsoft SQL Server max degree of parallelism (MAXDOP) configuration option controls the number of processors that are used for the execution of a query in a parallel plan.

This topic has been discussed for many years, the best practices have changed more than once (see my old post about it –

Continue Reading rstefanetti’s Article on their blog

https://robertostefanettinavblog.com/2019/12/16/configure-maxdop-max-degree-of-parallelism-on-sql-server-2016-2019/

Blog Syndicated with rstefanetti’s Permission

Leave a reply

Join Us
  • X Network2.1K
  • LinkedIn3.8k
  • Bluesky0.5K
Support The Site
Events
February 2025
MTWTFSS
      1 2
3 4 5 6 7 8 9
10 11 12 13 14 15 16
17 18 19 20 21 22 23
24 25 26 27 28   
« Jan   Mar »
Follow
Sign In/Sign Up Sidebar Search
Popular Now
Loading

Signing-in 3 seconds...

Signing-up 3 seconds...