NUMA

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 715375

    Comments posted to this topic are about the item NUMA

  • M&M

    SSC-Insane

    Points: 21679

    Thank you Steve

    M&M

  • DugyC

    Hall of Fame

    Points: 3804

    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 :unsure:

    _____________________________________________________________________
    [font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]

  • calvo

    SSChampion

    Points: 12930

    Woo! And I thought I would never need the NUMA knowledge obtained a few days ago.

    Thanks Gail/Steve!

    ______________________________________________________________________________________________
    Forum posting etiquette.[/url] Get your answers faster.

  • Andy sql

    SSCrazy Eights

    Points: 9369

    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

  • Gobikannan

    SSCrazy

    Points: 2735

    Thanks for the question.

    -----------------
    Gobikannan

  • SQLRNNR

    SSC Guru

    Points: 281210

    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[/url]
    Learn Extended Events

  • brdudley

    SSCrazy

    Points: 2268

    So which type of NUMA is used when dancing? I think I might need to ask my kids...

  • TomThomson

    SSC Guru

    Points: 104765

    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

  • Gail Shaw

    SSC Guru

    Points: 1004446

    Tom.Thomson (6/15/2011)


    Unless they just don't know what the acronyms stand for.

    That.

    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
  • DugyC

    Hall of Fame

    Points: 3804

    Tom.Thomson (6/15/2011)


    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.

    As Soft-NUMA was primarily designed to combat SMP architecture I think it is a fairly understandable error to make.

    _____________________________________________________________________
    [font="Comic Sans MS"]"The difficult tasks we do immediately, the impossible takes a little longer"[/font]

  • Koen Verbeeck

    SSC Guru

    Points: 258927

    Nice question, thanks.

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

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

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