up vote 0 down vote favorite
share [g+] share [fb]

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.

link|improve this question
feedback

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. See the FAQ for guidance on how to improve it.

1 Answer

up vote 1 down vote

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.

link|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
feedback

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