Post reply

NUMA - Node

  • November 5, 2013 at 2:24 pm

    #285823

    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

    #1664280

    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

    http://blogs.msdn.com/b/psssql/archive/2011/11/11/sql-server-clarifying-the-numa-configuration-information.aspx

    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

    #1664499

    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

    #1664518

    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

    #1664920

    Counter Objects Node Pages Size(GB)

    ----------------------------------------------------------------------

    SQLServer:Buffer NodeTotal pages 000 89788

    SQLServer:Buffer NodeTotal pages 001 3291732

    memory_node_idvirtual_address_space_committed_kbvirtual_address_space_reserved_kb

    ------------------------------------------------------------------------------------------

    08672887168

    1863048202182176

    64 26562752

    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