Post reply

NUMA

  • July 6, 2011 at 11:37 pm

    #100768

    Comments posted to this topic are about the item NUMA

  • July 6, 2011 at 11:37 pm

    #1349437

    Nice question, thanks.

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

  • July 7, 2011 at 1:50 am

    #1349457

    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'.

  • July 7, 2011 at 2:59 am

    #1349491

    Thanks for the question Steve.

  • July 7, 2011 at 5:11 am

    This was removed by the editor as SPAM

  • July 7, 2011 at 5:14 am

    #1349562

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

    http://brittcluff.blogspot.com/

  • July 7, 2011 at 6:11 am

    #1349611

    sys.dm_os_memory_nodes exits in sql 2008 and above.

  • July 7, 2011 at 6:15 am

    #1349615

    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

  • July 7, 2011 at 7:23 am

    #1349679

    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]

  • July 7, 2011 at 7:47 am

    #1349706

    Thank you for your replies.

  • July 7, 2011 at 10:24 am

    #1349816

    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

  • July 7, 2011 at 10:53 am

    #1349841

    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

  • July 7, 2011 at 1:40 pm

    #1349985

    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?

    😎

  • July 7, 2011 at 1:48 pm

    #1349997

    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

  • July 7, 2011 at 2:09 pm

    #1350024

    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