Author Topic: What is the recommended setting for MAXDOP?  (Read 160 times)

Offline Ahmad

  • 1
  • Newbie
  • *
  • Posts: 0
  • Karma: +0/-0
    • View Profile
What is the recommended setting for MAXDOP?
« on: October 24, 2014, 11:36:54 AM »
Hello everyone, I would like to ask you for help, or at least information, what is the recommended setting for maxdop? Thank you very much for informing me !!!



Offline Ciaran

  • 1
  • Newbie
  • *
  • Posts: 0
  • Karma: +0/-0
    • View Profile
Re: The recommended setting for
« Reply #1 on: October 30, 2017, 11:41:47 PM »
MAXDOP should not be 0 and should not be greater than half the number of visible schedulers.

For example if you have a quad core processor with hyper-threading enable, then you will have 4x2=8 visible schedulers (each scheduler is mapped to an individual processor).

Schedulers can be seen by running this query and would be the rows that have a scheduler_id < 255:

SELECT *
FROM sys.dm_os_schedulers
WHERE scheduler_id < 255;


 

Sitemap 1 2 3 4 5 6 7 8 9