Prev: Need help (again) with hierarhyID
Next: Recursive (Instead Of) Trigger
From: John Couch on 22 Apr 2010 10:19
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
 | 
Pages: 1
Prev: Need help (again) with hierarhyID
Next: Recursive (Instead Of) Trigger