Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

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
1  
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
add comment

1 Answer

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
add comment

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.