NUMA

  • Comments posted to this topic are about the item NUMA

  • Nice question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • I may be exposing my ignorance, but is this applicable to SQL server 2008 R2 only?

    I get this result in earlier versions of SQL Server:

    Invalid object name 'sys.dm_os_memory_nodes'.

  • Thanks for the question Steve.

  • This was removed by the editor as SPAM

  • This applicable to SQL Server 2008 and above. It's not available in 2005 I believe.

    http://brittcluff.blogspot.com/

  • sys.dm_os_memory_nodes exits in sql 2008 and above.

  • Learned a lot from this question. Had to do a lot of reading to find the answer, as I mostly deal with non-administration side of SQL Server. Thanks for the question Steve.

    [font="Verdana"]Please don't go. The drones need you. They look up to you.[/font]
    Connect to me on LinkedIn

  • The source cited has the following statement:

    Nodes are created per physical NUMA memory nodes

    But, as it always is, how does one determine the number of soft NUMA nodes?

    Anyone.

    If everything seems to be going well, you have obviously overlooked something.

    Ron

    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Thank you for your replies.

  • bitbucket-25253 (7/7/2011)


    The source cited has the following statement:

    Nodes are created per physical NUMA memory nodes

    But, as it always is, how does one determine the number of soft NUMA nodes?

    Anyone.

    It seems you need to query the registry to determine this. It's possible that a query somewhere would show you NUMA nodes in the SQLOS, but unless you knew if you had NUMA hardware, it might be hard to determine if those are hard or soft NUMA.

    http://msdn.microsoft.com/en-us/library/ms345357.aspx

  • sweet - thanks to Dr DMV scripts this should be straight forward.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Nice question. I like the NUMA and other new toechnology questions and the high percentage of right answers.

    I also am curious about those of you that mentioned this view is not in SQL 2005.

    Is this information available in any SQL 2005 DMV?

    😎

  • Britt Cluff (7/7/2011)


    This applicable to SQL Server 2008 and above. It's not available in 2005 I believe.

    This DMV is only in SQL Server 2008 and above, but limited NUMA use started in SQL 2000 sp4.

    http://technet.microsoft.com/en-us/library/ms180954(SQL.90).aspx

    For SQL 2005:

    "On startup, Database Engine writes the node information to the error log. To determine the node number of the node you want to use, either read the node information from the error log, or from the sys.dm_os_schedulers view."

    http://technet.microsoft.com/en-us/library/ms345346(SQL.90).aspx

  • Every time I see NUMA I think about Clive Cussler and Dirk Pitt..

    CEWII

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply