Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

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?

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

1 Answer 1

up vote 2 down vote accepted

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.

share|improve this answer
    
Nice link. I wish I could've been at that PASS demo! –  Richard Aug 18 '11 at 14:24

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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