5

I was reading up on Non-Uniform Memory Access (NUMA) and I was wondering how much of a difference it can really make? Another way to word that, what level of throughput is required before this becomes beneficial?

Also, what type of server do you need to look for when you want a system with multiple system busses?

  • Related: Shawn's answer lead me to this beautiful demo of NUMA using Intel's Quickpath Architecture. – Richard Aug 18 '11 at 14:29
3

Jonathan Kehayias did a good blog post on NUMA at SQLSkills.com.

I believe server wise most of the vendors out there note if they are NUMA capable servers or not. From reading Jonathan's post it seems the focus is on the motherboard and processor capabilities. Then I would imagine how they interconnect would be an important thing to note as well, since that would be the bottleneck in most cases.

I have not really seen anyone write up on when NUMA becomes beneficial. I think it would just be a analysis on what your system is going to need. If one server maxed out to the nines is not going to cut it for the workload, then look at the alternatives.

  • Nice link. I wish I could've been at that PASS demo! – Richard Aug 18 '11 at 14:24

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.