Tim
asked on
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.
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.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
honor system!
Licensing by Microsoft is based on CORES in the HOST!
Just create a VM using Sockets.
Licensing by Microsoft is based on CORES in the HOST!
Just create a VM using Sockets.
ASKER
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?
ASKER
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?