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

We currently have a physical server with 4 physical cpu. Which will be the best VM configuration for SQL Server?

If I configure my native server I will have much better performance because I will not be limited by only 4 CPUs. So is there a way to assign physical CPUs with Hyper-V so that the guest gets access to the entire CPU (and all its cores) rather than just the cores being presented as individual CPUs?

share|improve this question
a 4 vcpu limit has not been a limiting factor in our case, its always io or ram or both. – tony roth Jul 13 '10 at 20:55

No, the VM is limited to 4 vCPUs under Hyper-V. Each vCPU is a single core in the physical world. If you need more than 4 cores for your database server then it isn't a good candidate for virtualization.

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.