number of CPUs that are assigned to each NUMA node

Hello,
SQL Server STD edition with sp2 plus cumlative update package 2
os = 2003 enterprise edition 64 bit.
After looking at http://support.microsoft.com/kb/329204
I was wondering how to detect the number of CPUs that are assigned to each
NUMA node.
I have issued the following :
SELECT DISTINCT memory_node_id
FROM sys.dm_os_memory_clerks
with the return of:
Memory_node_id
0
3
1
2
I believe this indicates that hardware NUMA is enabled.
This box has 4 dual core procs.
TIA,Yes, and I believe that relates back to parent_node_id in
sys.dm_os_schedulers
--
Jason Massie
Web: http://statisticsio.com
RSS: http://feeds.feedburner.com/statisticsio
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:A7FB4D85-F710-4CC1-843C-8A8D80D167BB@.microsoft.com...
> Hello,
> SQL Server STD edition with sp2 plus cumlative update package 2
> os = 2003 enterprise edition 64 bit.
> After looking at http://support.microsoft.com/kb/329204
> I was wondering how to detect the number of CPUs that are assigned to each
> NUMA node.
> I have issued the following :
> SELECT DISTINCT memory_node_id
> FROM sys.dm_os_memory_clerks
> with the return of:
> Memory_node_id
> 0
> 3
> 1
> 2
> I believe this indicates that hardware NUMA is enabled.
> This box has 4 dual core procs.
> TIA,sql