Need help understanding how to optimize VM SQL server

This question has to do with VMWare and configuring VM machines more specifically SQL server. I am running ESXi 6.0 on a server that has 2 sockets and 8 cores per socket running at 2.4GHz with 60GB of memory. On this host we have 7 VM's running and I feel these machines are impacting my SQL server. The SQL server is on Windows 2012 R2 Standard and the version of SQL is 2012.

Now my question, How many sockets and cores do I assign to all the machines so that everything runs smoothly. I am a bit confused with the virtual sockets and virtual cores and how they relate. I have read that Windows 2012 R2 has a limit of 2 sockets but don't know how many cores. I have also read that the total number of cores used by all VM's on the host should not exceed the hosts physical core count which would be 16 for this host.
TimSr. System AdminAsked:
Who is Participating?

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

x
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.

Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
forget assigning cores, unless you have specific licensing requirements e.g. you are licensed by cores.

assign sockets to all VMs e.g. 2 sockets x 1 core

have you read this guide

Architecting Microsoft SQL Serveron VMware vSphere®
0

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
TimSr. System AdminAuthor Commented:
I have that document printed out but have not read it thoroughly. I was hoping to get a better understanding on how cores and sockets work without reading the whole document.

When I was licensing Windows 2012 R2 for our SQL server the Microsoft agent mentioned sockets and cores and that Microsoft had gone to licensing cores and not sockets. Is there way to see how 2012 is licensed and how many cores it is licensed for? Does this work on the honor system or do the activation codes for the OS determine how many cores you can run?
0
Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
honor system!

Licensing by Microsoft is based on CORES in the HOST!

Just create a VM using Sockets.
0
TimSr. System AdminAuthor Commented:
Thanks I will configure the server to use Sockets and not cores. Now when it comes to hyperthreading. My server has 1 socket with 6 cores and with Hyperthreading it says it has 12 virtual cores. I am running two 2012 r2 servers as remote desktops can I give each server 6 sockets each without hurting performance? Or should I just stick to 3 sockets with one core?
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
Virtualization

From novice to tech pro — start learning today.