Wednesday, January 13, 2010

NUMA Madness with SQL Server 2008 and Windows Server 2008 R2

This blog post has moved:

http://www.brettflippin.com/archive/2010/01/numa-madness-with-sql-server-2008-and-windows-server-2008-r2/
Posted by Brett Flippin at 2:23 PM
Labels: ,

2 comments:

  1. UnknownJanuary 13, 2010 at 4:03 PM

    I don't think it's MAXDOP. I wonder if the memory nodes are improperly configged in hardware - can you run this?

    SELECT
    memory_node_id AS [Memory Node],
    SUM(single_pages_kb) AS [Single Pages Kb],
    SUM(multi_pages_kb) AS [Multi Pages Kb],
    SUM(awe_allocated_kb) AS [AWE Allocated Memory Kb]
    FROM sys.dm_os_memory_clerks
    GROUP BY memory_node_id;

    ReplyDelete
  2. Brett FlippinJanuary 13, 2010 at 4:11 PM

    Here are the results of the query, sorry about the mess on this one:

    MemNode,SinglePagesKb,MultiPagesKb,AWEMemKb
    0,4312,11128,0
    1,251984,34528,0

    ReplyDelete

Subscribe to: Post Comments (Atom)