Dedicated DRS cluster for Big VMs to avoid CPU ready issue?

People,

I've got several VMs (~7 VMs) that is running SQL Server 2012 and SharePoint 2013 servers with 4x vCPU, 6x vCPU and some 8x vCPU, the CPU ready percentage is considered high as per http://www.vmcalc.com/ guidelines after taking the number from vSPhere clients.

So I would like to move those big VMs into separate DRS cluster of 4x ESXi servers. Would that be a good idea ?
because at the moment it is running on 8 nodes cluster with many other VMs 1x vCPU and 2x vCPU mostly.

if anyone know what's the best steps to optimize it, then please let me know.

Thanks.
LVL 9
Senior IT System EngineerIT ProfessionalAsked:
Who is Participating?
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.

Senior IT System EngineerIT ProfessionalAuthor Commented:
According to my Developers and Database support team, the SQL Server agent & Scheduled script runs twice as fast in their Core i7 laptop compares to the VMware environment.

So I'm hard pressed to add more vCPU to the 8x vCPU VMs and 4x vCPU VMs to resolve this pefromance issue.
0
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
Your Developers observations are correct, the scripts they are running on their laptops will run faster, but is this a true test of performance, and what performance is desired of your virtual servers.

Is it affecting service the performance impact.

Virtualisation is a compromise, and peformance of SQL will always be slower under a hypervisor, than a physical server.

Allocate more vCPUs to your SQL Server. But if you are playing a game of trying to satisfy your developers and database support team, of trying to get SQL to run scripts as faster or faster than their laptops, do not virtualise the SQL servers, and run them on physical servers.

If you are thinking of moving your VMs to a dedicated farm of ESXi servers with DRS, why not save ESXi licenses, and just move the VMs to physical servers, so they can use all the physical resource.

have a read of this (my blog) I wrote, in 2009, SQL on ESXi or Hyper-V has not changed...

Video - Poor Microsoft SQL Performance caused by Virtualisation - Not all servers are equal!
0
Senior IT System EngineerIT ProfessionalAuthor Commented:
Hi Andrew,
It is real world production script not a test ones.

So yes I guess there is nothing much I can do here because ESXi servers are all running on HP Blades servers. I suppose it would be cheaper to run it on HP Proliant DL rack servers than physical blade servers with similar CPU sockets.

Performance wise I think there is no different between blades and rack servers. Is that correct ?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
I appreciate it's a real world production script, and you Developers and Database operators have observed, that it runs faster on their laptops than your virtual machine - BUT IS THAT A PROBLEM?

Does that affect service ?

If it does affect service, like in my blog article and video..... then you can try adding additional vCPUs, but I think you will find, that you may not reach the benchmark your Developers and Database operators have seen.

lets turn this around, and Ask your Database and Developers HOW MANY IOPS does the database require?

and does your virtual enviornment deliver those IOPS for the database ?

If however you are thinking of just running a single VM on an ESXi server - does this make commercial sense, due to additional cost and overhead of the Hypervisor ?

Some organisations, we work with have a policy of NO PHYSICAL, some organisations are only virtual, some still used MIXED virtual and physical, depending on what requirement fits best!
0
Senior IT System EngineerIT ProfessionalAuthor Commented:
Hi Andrew,
The iops on the data store is not a problem because the VMFS running on SSD.
0
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
I posted some questions for you to think about!

We been involved with virtualisation for 13 years, and not all workloads can be virtiualised, in our opinion, approx 90% only, 10% still need to run on physical hardware at present.

As well as what IOPS requirements do your Developers and Database operators require.

If you are seeking perfection, we would recommend you build on a physical solution. e.g. no hypervisor. where ALL the resources can then be dedicated to your Sharepoint Cluster and SQL DBs.
1

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
Senior IT System EngineerIT ProfessionalAuthor Commented:
Thanks !
0
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
VMware

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.