NUMA Node

  • Hi all,

    We have 16CPU servers. When i took a look at Errorlog log i have all this informational Message.

    Is this good or Bad for performance. No any of other production server we havn't enabled Numa.

    Multinode configuration: node 0: CPU mask: 0x00000000000000f0 Active CPU mask: 0x00000000000000f0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.

    Multinode configuration: node 1: CPU mask: 0x000000000000000f Active CPU mask: 0x000000000000000f. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.

    Multinode configuration: node 2: CPU mask: 0x0000000000000f00 Active CPU mask: 0x0000000000000f00. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.

    Multinode configuration: node 3: CPU mask: 0x000000000000f000 Active CPU mask: 0x000000000000f000. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.

    Thanks

    EMA

  • azhagumuthu

    As to my knowledge it’s just showing the number of CPU nodes.

    And it is also for informational message only.

    Is it first time coming after you configured NUMA?

    Thanks,

    Raj

  • Raj,

    Thanks for the reply. I havn't configured any softNuma. We have many production server & i havn't seen this message so fas,so i was curious is this going to affect our production in any way.

  • All it's saying is that the server uses a NUMA architecture (non-uniform memory access) and it's showing you how the NUMA nodes are configured. When the server uses the NUMA architecture, you don't need to configure anything, SQL detects it and adapts correctly

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • MSDN NUMA Blog. There's some nice information here:

    http://blogs.msdn.com/psssql/archive/2008/01/24/how-it-works-sql-server-2005-numa-basics.aspx

  • Hi,

    In SQL Server you can configure two types of the NUMA architecture

    1. Harware NUMA which was already enable by Server /H.W designer and your sever will always have Hardware NUMA enable then you will get this message in the SQL Server as SQL Server smart enough to detect H.W NUMA

    2. Software NUMA which we have to configure at SQL Server level for more information about it please go through the

    following link

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

    Regards,

    Nirav Joshi

  • Thanks for everyone reply. That was helpful.

  • I sure wish there was more information available about NUMA and how SQL Server uses it and how it can affect performance. πŸ™

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • I think Gails post sums it pretty well. It isnt something you need to concern yourself with.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • TheSQLGuru (9/3/2009)


    I sure wish there was more information available about NUMA and how SQL Server uses it and how it can affect performance. πŸ™

    There was a whole presentation on NUMA at PASS either 2005 or 2006. It was done by two guys from either the SQL dev team or PSS, I don't have names offhand, but I might be able to find them. If I can, might be worth contacting them, asking if the presentation is publicly available.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • GilaMonster (9/3/2009)


    TheSQLGuru (9/3/2009)


    I sure wish there was more information available about NUMA and how SQL Server uses it and how it can affect performance. πŸ™

    There was a whole presentation on NUMA at PASS either 2005 or 2006. It was done by two guys from either the SQL dev team or PSS, I don't have names offhand, but I might be able to find them. If I can, might be worth contacting them, asking if the presentation is publicly available.

    That would be nice. I had acquired some insider information from some HP engineers for particular work but it wasn't publicly disseminable (coining a new word there?).

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • I'll dig through old papers. No promises though. If I find the slides I'll mail you the presenters' names.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • GilaMonster (9/3/2009)


    I'll dig through old papers. No promises though. If I find the slides I'll mail you the presenters' names.

    Hey Gail, I was just wondering if you ever had a chance to find this info - I'm chasing down a performance issue with stats gathering on a weekend maintenance job and I'm highly suspicious that NUMA configuration is playing a big part in the equation.

    On lower lane servers which have 2 - 4 NUMA nodes (distinct memory clerk IDs recognized by SQL Server), stats gathering runs normally using a backup from production - so I know its not "distribution" related. In my production lane it runs slowly but there's only one distinct memory node to work with.

Viewing 13 posts - 1 through 12 (of 12 total)

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