NUMA Node

Question

Post reply

NUMA Node

azhagumuthu

SSCrazy

Points: 2460
More actions
August 31, 2009 at 3:43 pm

#225563

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

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

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

rajdba Ten Centuries Points: 1362 More actions · Answer 1

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

azhagumuthu SSCrazy Points: 2460 More actions · Answer 2

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.

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

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

Steve-3_5_7_9 SSChampion Points: 10832 More actions · Answer 4

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

Nirav_Joshi SSC-Addicted Points: 491 More actions · Answer 5

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

azhagumuthu SSCrazy Points: 2460 More actions · Answer 6

azhagumuthu

SSCrazy

Points: 2460

September 3, 2009 at 7:24 am

#1048714

Thanks for everyone reply. That was helpful.

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 7

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

Silverfox SSC-Insane Points: 23150 More actions · Answer 8

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]

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 9

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

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 10

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 11

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

Jeremy Brown SSCarpal Tunnel Points: 4223 More actions · Answer 12

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.