Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I am little bit confused about single core processor based SQL server or dual processor based SQL server.

We are planning to purchase SQL server 2008 Standard R2.

People are asking whether it is for single processor or dual processor. So, what's the difference between them?

If I've installed a single processor based SQL, then what happens?

My server has 2 quad core processors.

share|improve this question

closed as not a real question by slhck, Dave M, Sathya Dec 9 '11 at 4:57

It's difficult to tell what is being asked here. This question is ambiguous, vague, incomplete, overly broad, or rhetorical and cannot be reasonably answered in its current form. For help clarifying this question so that it can be reopened, visit the help center.If this question can be reworded to fit the rules in the help center, please edit the question.

add comment

1 Answer

It has to do primarily with licensing. If you only purchase a license for a single CPU version and install it on a machine with 4 CPUs available, then it will only take advantage of 1 of the 4 CPUs, leaving 3 CPUs either wasted or usable for other tasks. This allows Microsoft to provide the same quality product at different price points. This let's smaller businesses that may not need the heavy lifting of a 12 core server behind their database to afford the same product and then upgrade later if the need and funding are great enough.

share|improve this answer
    
It's also important to note that Microsoft licences by the number of physical sockets, not the number of logical cores. –  afrazier Dec 8 '11 at 22:32
    
do it any compliance issue if i will use single processor SQL –  Pawan Yadav Dec 9 '11 at 5:20
    
Thanks all for your time !!! –  Pawan Yadav Dec 27 '11 at 9:05
add comment

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