Share via

Understanding of SQL Server documentation

Robert L. Streicher 81 Reputation points
2022-09-08T23:55:56.607+00:00

This SQL Server documentation page states that:

SQL Server ignores NUMA configuration when hardware NUMA has four or less CPUs and at least one node has only one CPU.

  1. This sentence seems indicate that different physical NUMA node could have different number of physical CPUs. Is this true?
  2. I don't quite understand the logic here (maybe because I'm not a native English speaker). Does the following pseudo code represent the logic in the excerpt? fn is_sql_server_ignores_numa () {
    one_node_has_one_cpu = false
    for node in all_numa_nodes:
    if node.cpu_count() == 1:
    one_node_has_one_cpu = true
       less_then_or_equal_to_4 = true  
       for node in all_numa_nodes:  
           if node.cpu_count() > 4:  
       less_then_or_equal_to_4 = false  
    
       return one_node_has_one_cpu && less_then_or_equal_to_4  
    
    }
SQL Server | Other
SQL Server | Other

Additional SQL Server features and topics not covered by specific categories

0 comments No comments

Answer accepted by question author

S.Sengupta 30,906 Reputation points MVP Volunteer Moderator
2022-09-09T00:11:51.933+00:00

I shall suggest you to go through the following :

SQL Server: Clarifying The NUMA Configuration Information

Was this answer helpful?

1 person found this answer helpful.
0 comments No comments

1 additional answer

Sort by: Most helpful
  1. CathyJi-MSFT 22,431 Reputation points Microsoft External Staff
    2022-09-09T06:57:01.963+00:00

    Hi @Robert L. Streicher ,

    > This sentence seems indicate that different physical NUMA node could have different number of physical CPUs. Is this true?

    Yes, you are right.


    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?

    1 person found this answer helpful.
    0 comments No 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.