2 added 42 characters in body
source | link

SQL is NUMANUMA aware so you can find NUMANUMA info using a query. You can also use this query to see how many NUMANUMA nodes you have and which CPU and cores are assigned to which NUMANUMA:

SELECT parent_node_id, scheduler_id, cpu_id FROM sys.dm_os_schedulers WITH (NOLOCK) WHERE [status] = N'VISIBLE ONLINE';

SELECT parent_node_id, scheduler_id, cpu_id
FROM sys.dm_os_schedulers WITH (NOLOCK) 
WHERE [status] = N'VISIBLE ONLINE';

Or just how many NUMANUMA:

SELECT COUNT(Distinct Parent_node_id) FROM sys.dm_os_schedulers WHERE [STATUS] = 'VISIBLE ONLINE' AND Parent_node_ID < 64

select COUNT(distinct Parent_node_id)
from sys.dm_os_schedulers
where [STATUS] = 'VISIBLE ONLINE'
    and Parent_node_ID < 64

SQL is NUMA aware so you can find NUMA info using a query. You can also use this query to see how many NUMA nodes you have and which CPU and cores are assigned to which NUMA:

SELECT parent_node_id, scheduler_id, cpu_id FROM sys.dm_os_schedulers WITH (NOLOCK) WHERE [status] = N'VISIBLE ONLINE';

Or just how many NUMA:

SELECT COUNT(Distinct Parent_node_id) FROM sys.dm_os_schedulers WHERE [STATUS] = 'VISIBLE ONLINE' AND Parent_node_ID < 64

SQL is NUMA aware so you can find NUMA info using a query. You can also use this query to see how many NUMA nodes you have and which CPU and cores are assigned to which NUMA:

SELECT parent_node_id, scheduler_id, cpu_id
FROM sys.dm_os_schedulers WITH (NOLOCK) 
WHERE [status] = N'VISIBLE ONLINE';

Or just how many NUMA:

select COUNT(distinct Parent_node_id)
from sys.dm_os_schedulers
where [STATUS] = 'VISIBLE ONLINE'
    and Parent_node_ID < 64
1
source | link

SQL is NUMA aware so you can find NUMA info using a query. You can also use this query to see how many NUMA nodes you have and which CPU and cores are assigned to which NUMA:

SELECT parent_node_id, scheduler_id, cpu_id FROM sys.dm_os_schedulers WITH (NOLOCK) WHERE [status] = N'VISIBLE ONLINE';

Or just how many NUMA:

SELECT COUNT(Distinct Parent_node_id) FROM sys.dm_os_schedulers WHERE [STATUS] = 'VISIBLE ONLINE' AND Parent_node_ID < 64