Get the NUMA Configuration

SELECT @@SERVERNAME, 
SERVERPROPERTY('ComputerNamePhysicalNetBIOS') AS [Local Machine Name],  
(cpu_count / hyperthread_ratio) AS [Physical CPUs],  
hyperthread_ratio AS [Hyperthread Ratio],  
cpu_count AS [Logical CPUs],  
softnuma_configuration AS [Soft-NUMA Configuration],  
softnuma_configuration_desc AS [Soft-NUMA Description],  
socket_count AS [Available Sockets],  
numa_node_count AS [Available NUMA Nodes]  
FROM  
sys.dm_os_sys_info;  

• ComputerNamePhysicalNetBIOS is the NetBIOS name of the machine where the SQL Server instance is running.
• cpu_count is the number of logical CPUs.
• hyperthread_ratio is the number of CPUs exposed on a single socket.
• softnuma_configuration is set to 0 (off, using hardware defaults), 1 (automated soft-NUMA), or 2 (manual soft-NUMA configuration via the registry).
• softnuma_configuration_desc is either OFF (the soft-NUMA feature is off), ON (SQL Server automatically determines the NUMA node sizes), or MANUAL (manual configuration).
• socket_count is the number of available processor sockets.
• numa_node_count is the number of available NUMA nodes.