SQL Server NUMA Node information

Gives you some useful information about the composition and relative load on your NUMA nodes

SELECT node_id
	,node_state_desc
	,memory_node_id
	,processor_group
	,cpu_count
	,online_scheduler_count
	,idle_scheduler_count
	,active_worker_count
	,avg_load_balance
	,resource_monitor_state
FROM sys.dm_os_nodes WITH (NOLOCK)
WHERE node_state_desc <> N'ONLINE DAC'
OPTION (RECOMPILE);

Check an equal number of schedulers on each NUMA node

Check on a physical or virtual machine with more than four sockets or more than 24 physical cores

Microsoft help

Other Link

https://www.sqlskills.com/blogs/glenn/balancing-your-available-sql-server-core-licenses-evenly-across-numa-nodes/

Spread the love