Share via

Recommended Numa Node configuration number and Max DOP

mo boy 396 Reputation points
2022-06-20T10:17:14.843+00:00

Dear Experts,

On my SQL Server 2017 standard edition on Windows Server 2016 standard, I see there are 3 NUMA nodes

1st one has 4 processors
2nd one has 3 processors
3rd one has 3 processors

I also see MaxDOP is disabled (set to 1). CPU keeps fluctuating and sometimes it differs a lot across the NUMA nodes.

My feeling is with this number of NUMA nodes, there may be some kind of imbalance causing issues. Also, we may need to enable MaxDOP to 4 ?

Please advise?

SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. CathyJi-MSFT 22,426 Reputation points Microsoft External Staff
    2022-06-21T02:42:17.963+00:00

    Hi @mo boy ,

    Quote from MS document ;

    >Starting with SQL Server 2016 (13.x), during service startup if the Database Engine detects more than eight physical cores per NUMA node or socket at startup, soft-NUMA nodes are created automatically by default. The Database Engine places logical processors from the same physical core into different soft-NUMA nodes.

    213070-screenshot-2022-06-21-104052.jpg

    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Was this answer helpful?

    0 comments
  2. Tom Phillips 17,786 Reputation points
    2022-06-20T13:54:20.98+00:00

    It is completely normal for the CPU to be different across processors. That is not an indication of a problem.

    Was this answer helpful?

    0 comments

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.