November 5, 2013 at 2:24 pm
Hi,
I need to verify memory size of each NUMA node in the system. Please share me the method how to confirm that all the NUMA nodes are configured correctly.
Thanks.
November 5, 2013 at 4:06 pm
sudhakara (11/5/2013)
Hi,I need to verify memory size of each NUMA node in the system. Please share me the method how to confirm that all the NUMA nodes are configured correctly.
Thanks.
http://gavinpayneuk.files.wordpress.com/2012/09/numa-internals-of-sql-server-2012.pdf
dbcc memorystatus
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
November 6, 2013 at 9:17 am
SELECT node_id, node_state_desc, memory_node_id, online_scheduler_count,
active_worker_count, avg_load_balance
FROM sys.dm_os_nodes WITH (NOLOCK)
WHERE node_state_desc <> N'ONLINE DAC' OPTION (RECOMPILE);
November 6, 2013 at 10:28 am
eyespi20 (11/6/2013)
SELECT node_id, node_state_desc, memory_node_id, online_scheduler_count,
active_worker_count, avg_load_balance
FROM sys.dm_os_nodes WITH (NOLOCK)
WHERE node_state_desc <> N'ONLINE DAC' OPTION (RECOMPILE);
What information does this give you about the memory of each node?
Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service
November 7, 2013 at 1:54 pm
Counter Objects Node Pages Size(GB)
----------------------------------------------------------------------
SQLServer:Buffer Node Total pages 000 8978 8
SQLServer:Buffer Node Total pages 001 32917 32
memory_node_id virtual_address_space_committed_kb virtual_address_space_reserved_kb
------------------------------------------------------------------------------------------
0 86728 87168
1 863048 202182176
64 2656 2752
Can anybody explain why there is difference in the buffer node & os memory node dmv or Am I checking wrongly if so can you explain right way to understand this?
Thanks in Advance.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply