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 Expand / Collapse
Author
Message
Posted Monday, June 13, 2011 8:59 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: 2 days ago @ 3:11 PM
Points: 31,368, Visits: 15,837
Comments posted to this topic are about the item NUMA






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1124719
Posted Monday, June 13, 2011 8:59 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, November 19, 2014 2:03 PM
Points: 2,278, Visits: 3,806
Thank you Steve

Mohammed Moinudheen
Post #1124721
Posted Tuesday, June 14, 2011 3:31 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Tuesday, August 27, 2013 4:28 AM
Points: 1,248, Visits: 779
Ach... I used that msdn article as my reference before answering the question. However, nowhere does it mention "Software NUMA" but instead uses "Soft-NUMA" (which was not an answer option), especially when referring to SMP architecture.

Therefore this led me to believe "Software NUMA" was a trick, so I went for SMP as "Soft-NUMA" seemed to be originally designed to combat this architecture.

Ah well... at least I still learned something new


_____________________________________________________________________
"The difficult tasks we do immediately, the impossible takes a little longer"
Post #1124835
Posted Tuesday, June 14, 2011 5:53 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 6:20 AM
Points: 1,269, Visits: 3,635
Woo! And I thought I would never need the NUMA knowledge obtained a few days ago.
Thanks Gail/Steve!


______________________________________________________________________________________________
Forum posting etiquette. Get your answers faster.
Post #1124892
Posted Tuesday, June 14, 2011 6:16 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 8:29 AM
Points: 1,067, Visits: 1,148
Thanks for the question - a subject area I had no idea about, until reading the linked MSDN article (after getting the answer wrong, of course!). Exactly what QotD should do for us.

Keep up the good work Steve
Andy
Post #1124912
Posted Tuesday, June 14, 2011 6:29 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Tuesday, December 9, 2014 5:12 AM
Points: 1,981, Visits: 588
Thanks for the question.

-----------------
Gobikannan
Post #1124922
Posted Tuesday, June 14, 2011 9:05 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 2:39 PM
Points: 18,064, Visits: 16,108
Brain Stumper this time.



Jason AKA CirqueDeSQLeil
I have given a name to my pain...
MCM SQL Server, MVP


SQL RNNR

Posting Performance Based Questions - Gail Shaw
Post #1125085
Posted Tuesday, June 14, 2011 10:04 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Tuesday, December 9, 2014 9:45 AM
Points: 1,446, Visits: 1,603
So which type of NUMA is used when dancing? I think I might need to ask my kids...
Post #1125146
Posted Wednesday, June 15, 2011 2:10 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 4:21 PM
Points: 7,928, Visits: 9,653
Nice simple question.

I guess about two thirds getting it right is reasonable, as it's something a lot of people will not have come across. But currently 16% have picked "SMP" which startled me - evidently they don't see that S (Symmetric) and NU (NonUniform) are orthogonal/independent, as are MP (MultiProcessing) and MA (Memory Access). Unless they just don't know what the acronyms stand for.


Tom
Post #1125503
Posted Wednesday, June 15, 2011 2:44 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 @ 9:22 AM
Points: 40,632, Visits: 37,094
Tom.Thomson (6/15/2011)
Unless they just don't know what the acronyms stand for.


That.



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 #1125518
« Prev Topic | Next Topic »

Add to briefcase 12»»

Permissions Expand / Collapse