Hyper-V processor resource control


I have a Hyper-V server with 16 cores, running on Server 2008 R2. In this version, I know I can assign only for processors to a VM in 2008. On one of the VMs I'm running a SQL server and at one point all 4 processors were running at 100% while on the host, the processors were running at 1-2%. How is this possible and how would I assign more power to that SQL VM?

Thank you!
Alan DalaITAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Philip ElderTechnical Architect - HA/Compute/StorageCommented:
SQL is its own breed when it comes to resources.

If SQL is pinning in 08 R2 then 2012 R2 should be considered.

If SQL is so resource hungry that it's taking up a lot on a 2012 R2 host then physical is the only way to go.
Alan DalaITAuthor Commented:
Thanks for your answer. I know 2012 R2 upgrade needs to be addressed  soon. I was just wondering if meantime there is a way to assign priority to specific VMs in 2008 R2.

Thanks again.
Philip ElderTechnical Architect - HA/Compute/StorageCommented:
If you are pinning the maximum number of vCPUs in 08 R2? If yes, there's nothing much more that can be done short of throwing more physical CPU at it or moving to 2012 R2.
IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

Alan DalaITAuthor Commented:
Sorry if I sound dense but what do you mean by  'throwing more physical CPU'? Are you saying to potentially moving the SQL to a physical server? I already assigned the max. 4 vCPUs 2008R2 is capable of. I know there is a work around by editing the XML file and manually adding 8 CPUs but it is not supported by Microsoft. I'm tempted to try it since this 4 CPUs cap is very frustrating.

Philip ElderTechnical Architect - HA/Compute/StorageCommented:

It is what it is.

Your options are pretty clear to me:

1. Move to 2012 R2 and new hardware

2. Move to physical hardware

3. Move to 2012 R2 on existing hardware

We would not "tweak" any settings to try and extract more performance out of an older platform. That's just asking for trouble.
Alan DalaITAuthor Commented:
I figured.

Thanks. I appreciate the help.
Philip ElderTechnical Architect - HA/Compute/StorageCommented:
No worries.

If you need to V2P (virtual to physical) there are a lot of great tools out there. Our preferred product of choice is ShadowProtect by StorageCraft.

Or, you can install fresh and detach/attach the databases from/to servers.

There are ways to make the process relatively painless unless the app vendors have AD based users added into database security with permission sets based on that. That's painful.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.