Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12»»

NUMA Node Expand / Collapse
Author
Message
Posted Monday, August 31, 2009 3:43 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, July 16, 2012 2:40 PM
Points: 1,614, Visits: 176
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
Post #780308
Posted Monday, August 31, 2009 3:58 PM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, March 24, 2014 11:35 PM
Points: 100, Visits: 405
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
Post #780315
Posted Monday, August 31, 2009 8:17 PM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, July 16, 2012 2:40 PM
Points: 1,614, Visits: 176
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.
Post #780408
Posted Tuesday, September 1, 2009 2:30 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:53 PM
Points: 42,771, Visits: 35,870
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 2008, MVP
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

Post #780499
Posted Wednesday, September 2, 2009 7:10 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 7:01 AM
Points: 914, Visits: 1,431
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



Post #781403
Posted Wednesday, September 2, 2009 1:20 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, July 23, 2014 9:11 AM
Points: 8, Visits: 177
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
Post #781765
Posted Thursday, September 3, 2009 7:24 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Monday, July 16, 2012 2:40 PM
Points: 1,614, Visits: 176
Thanks for everyone reply. That was helpful.
Post #782149
Posted Thursday, September 3, 2009 7:30 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 4:09 PM
Points: 4,343, Visits: 6,151
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 at GMail
Post #782155
Posted Thursday, September 3, 2009 7:37 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Friday, August 15, 2014 3:04 AM
Points: 2,728, Visits: 1,116
I think Gails post sums it pretty well. It isnt something you need to concern yourself with.

--------------------------------------------------------------------------------------
Recommended Articles on How to help us help you and
solve commonly asked questions

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden
Managing Transaction Logs by Gail Shaw
How to post Performance problems by Gail Shaw
Help, my database is corrupt. Now what? by Gail Shaw
Post #782160
Posted Thursday, September 3, 2009 7:38 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:53 PM
Points: 42,771, Visits: 35,870
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 2008, MVP
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

Post #782162
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse