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?
Andrew Hancock (VMware vExpert / EE MVE^2)Connect With a Mentor 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®
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?
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.
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?
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.

All Courses

From novice to tech pro — start learning today.