[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


SQL server 2012 Standard in Vmware

Posted on 2014-08-20
Medium Priority
Last Modified: 2014-08-24

SQL 2012 standard supports 16 cores.  I was wondering what would be the best configuration in vmware to setup if I wanted this.

Would I do 4 sockets + core 4 cores as the sql configuration for best performance?
Question by:ts11
LVL 25

Accepted Solution

Zephyr ICT earned 750 total points
ID: 40275462
If you are not bound by licensing issues you can go the route you suggest (4 sockets + 4 core), if licensing is an issue, you're better off using less sockets and more cores ...  If you wanted this of course.

Always start "small" and monitor performance, then add sockets/cores when needed.
LVL 17

Expert Comment

by:Sajid Shaik M
ID: 40275520
Spravtek is right...
LVL 124

Assisted Solution

by:Andrew Hancock (VMware vExpert / EE MVE^2)
Andrew Hancock (VMware vExpert / EE MVE^2) earned 750 total points
ID: 40275550
Just assign sockets....

vSMP (virtual SMP) can affect virtual machine performance, when adding too many vCPUs to virtual machines that cannot use the vCPUs effectly, e.g. Servers than can use vSMP correctly :- SQL Server, Exchange Server.

This is true, many VMware Administrators, think adding lots of processors, will increase performance - wrong! (and because they can, they just go silly!). Sometimes there is confusion between cores and processors. But what we are adding is additional processors in the virtual machine.

So 4 vCPU, to the VM is a 4 Way SMP (Quad Processor Server), if you have Enterprise Plus license you can add 8, (and only if you have the correct OS License will the OS recognise them all).

If applications, can take advantage e.g. Exchange, SQL, adding additional processors, can/may increase performance.

So usual rule of thumb is try 1 vCPU, then try 2 vCPU, knock back to 1 vCPU if performance is affected. and only use vSMP if the VM can take advantage.

Example, VM with 4 vCPUs allocated!

My simple laymans explaination of the "scheduler!"

As you have assigned 4 vCPUs, to this VM, the VMware scheulder, has to wait until 4 cores are free and available, to do this, it has to pause the first cores, until the 4th is available, during this timeframe, the paused cores are not available for processes, this is my simplistic view, but bottom line is adding more vCPUs to a VM, may not give you the performance benefits you think, unless the VM, it's applications are optimised for additional vCPUs.

See here

see here


also there is a document here about the CPU scheduler



Author Comment

ID: 40275624

Originally I had assigned just sockets, but this SQL version will only run on 4 sockets and I was running into performance issues.  I then assigned 2 sockets and 4 cores per sockets and was seeing a performance gain with that, but after 6 months on that configuration I'm seeing some performance issues at peak load times.

I'll read these articles and experiment some as well.
LVL 62

Expert Comment

ID: 40276454
More processors do not essentially mean it will perform better.
1) many queries do not involve many tables , so they dont paralleleize at all
2) even paralellized the slowest sub-query determines overall time spent
More CPUs are needed if you really have lots of parallel queries that saturate say 2 vCPUs...
With more expensive vmware editions you can hot-plug vCPUs on the fly, (Windows and SQL server supports it). At least enable the option in case you get better licence in future.

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
In this article will go through how to backup a vPostgres DB from a broken vCenter Appliance and restore to a new vCenter Appliance.
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
This video shows you how to use a vSphere client to connect to your ESX host as the root user. Demonstrates the basic connection of bypassing certification set up. Demonstrates how to access the traditional view to begin managing your virtual mac…

872 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question