From: John Couch on
Ok, si if you run DBCC memorystatus on SQL Server 2005 or 2008 with NUMA
enabled or not, you will get different results returned based on the NUMA
architecture. Can someone tell me why on certain systems I get memory_node_id
= 32 and memory_node_id = 64? When I look in sys.dm_os_memory_clerks as MS
suggested to determine how many memory nodes I have I do not see these values
anywhere.

SELECT DISTINCT memory_node_id
FROM sys.dm_os_memory_clerks