SELECT DISTINCT memory_node_id FROM sys.dm_os_memory_clerks
SELECT cpu_count AS [Logical CPUs]
,cpu_count / hyperthread_ratio AS [Physical CPUs]
FROM sys.dm_os_sys_info
SELECT DISTINCT memory_node_id FROM sys.dm_os_memory_clerks
SELECT cpu_count AS [Logical CPUs]
,cpu_count / hyperthread_ratio AS [Physical CPUs]
FROM sys.dm_os_sys_info