Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

If i have a one processor license for ms sql 2008 can i just click to turn on the other processor in the event i buy another license?

share|improve this question
up vote 1 down vote accepted

By default, SQL Server 2008 sets the max degree of parallelism to '0' which is basically use all available processors for processing. I don't think that SQL Server licensing does any checking to see if you only have a one-processor license on a > 1 proc server. You could also set max degree of parallelism to '1' in a multi-proc server and still fall within the licensing guidelines.

It's my understanding that it's the honor system with regard to the licensing.

share|improve this answer
so its similar to sql 2000, thanks – Brandon Grossutti Sep 29 '09 at 21:51
and I believe is physical processor, not the amount of cores – Wayne Sep 29 '09 at 23:45

That won't cut it. You have to remove the extra processor from the server to be legit. Having the processor in the server, even if not using it requires a license.

share|improve this answer

Your Answer


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.