Check auto-numa is enabled

1 vote

1 answer

1675 views

sql-server sql-server-2017 numa

                          I run query

    select cpu_count, hyperthread_ratio, softnuma_configuration, softnuma_configuration_desc
    from sys.dm_os_sys_info
and got results, where said, that numa is off:

    cpu_count	hyperthread_ratio	softnuma_configuration	softnuma_configuration_desc
    32	        16	                0	                    OFF

Then I run another query

    SELECT name, value, value_in_use, minimum, maximum, [description], is_dynamic, is_advanced 
    FROM sys.configurations WITH (NOLOCK) 
    ORDER BY name OPTION (RECOMPILE);
and got result, where said, that auto-numa is not disabled

    name	                      value	value_in_use	
    automatic soft-NUMA disabled	0	         0	    

Where is the right info?

In Task Manager I see node0 and node1.

We use Microsoft SQL Server 2017 (RTM-GDR) (KB4583456) - 14.0.2037.2 (X64)   Nov  2 2020 19:19:59   Copyright (C) 2017 Microsoft Corporation  Standard Edition (64-bit) on Windows Server 2016 Standard 10.0  (Build 14393: )

I have this message in the log - does this mean NUMA is being used correctly and that I don't need to do anything else?

![](https://i.sstatic.net/J9HbI.png) 

Shows 8 cores:

![](https://i.sstatic.net/amJRL.png) 
                        

Asked by Novitskiy Denis (331 rep)

May 17, 2022, 10:58 AM
Last activity: May 23, 2022, 05:21 PM

Check auto-numa is enabled

Related Questions