RickEpnet
asked on
Windows 7 Update Powerpoint
I have been ask this question I would like to have a quality response. Please keep in mind the person asking the question is a database admin not a VMware expert. I have in mind what to say just need a good way to explain to him the way VMware works.
Host is
Dual X5650 2.67GHz HP DL380 72GB of RAM
The SQL server has 4 vCPU but is only using at the most about 1800 MHz. I think the disks would be more of an issue. Raid 5 SAS drive all local storage.
I have a question on how our ESX server platform works.
for example if we have a host that has 2 procs and each proc has 4 cores
and we create a single VM on that box and set that vm up so it has 1 cpu... will that CPU then consume or use 1 core of 1 proc?
The reason I am asking is I am doing some calculations on if we are really saving money if we move our sql server to 2 procs on a VM or if it would be cheaper to move it to a physical single proc 4 core machine. SQL license would be the same price but we would have 4 times the power.
Host is
Dual X5650 2.67GHz HP DL380 72GB of RAM
The SQL server has 4 vCPU but is only using at the most about 1800 MHz. I think the disks would be more of an issue. Raid 5 SAS drive all local storage.
I have a question on how our ESX server platform works.
for example if we have a host that has 2 procs and each proc has 4 cores
and we create a single VM on that box and set that vm up so it has 1 cpu... will that CPU then consume or use 1 core of 1 proc?
The reason I am asking is I am doing some calculations on if we are really saving money if we move our sql server to 2 procs on a VM or if it would be cheaper to move it to a physical single proc 4 core machine. SQL license would be the same price but we would have 4 times the power.
See here for SQL Virtual Licensing
http://ladylicensing.wordpress.com/2009/05/07/sql-2008-–-update-how-to-license-in-a-virtual-environment-rules-by-versionedition/
http://ladylicensing.wordpress.com/2009/05/07/sql-2008-–-update-how-to-license-in-a-virtual-environment-rules-by-versionedition/
This was the official Microsoft SQL License pdf, I was looking for...
http://download.microsoft.com/download/2/7/0/270B6380-8B38-4268-8AD0-F480A139AB19/SQL2008R2_LicensingQuickReference-updated.pdf
If you are looking for a price versus performance, the physical server will win, the physical server will have no hypervisor ovearhead. But it does depend on the SQL database, we have had to complete a few V2P of SQL virtual machines because performance suffered in a virtual environment.
http://download.microsoft.com/download/2/7/0/270B6380-8B38-4268-8AD0-F480A139AB19/SQL2008R2_LicensingQuickReference-updated.pdf
If you are looking for a price versus performance, the physical server will win, the physical server will have no hypervisor ovearhead. But it does depend on the SQL database, we have had to complete a few V2P of SQL virtual machines because performance suffered in a virtual environment.
ASKER
But the server is not even using 100% of even one CPU it would be best to reduce the vCPU to 2 right?
I think I understand this could you explain how this works a little more.
With your dual processor, quad core server, you will have a total of 8 cores that can be allocated to the VM as 1 vCPU.
I think I understand this could you explain how this works a little more.
With your dual processor, quad core server, you will have a total of 8 cores that can be allocated to the VM as 1 vCPU.
I would start with 1vCPU and if performance is poor, add another.
ASKER
I think I understand this could you explain how this works a little more.
With your dual processor, quad core server, you will have a total of 8 cores that can be allocated to the VM as 1 vCPU.
With your dual processor, quad core server, you will have a total of 8 cores that can be allocated to the VM as 1 vCPU.
Correct, or in theory add 8vCPU = 8 Cores!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I got the Resource Management Guide Link incorrect.
Adding many vCPUs to your virtual can slow it down because of the vSMP scheduler.
Its often better to start with 1, and increase to obtain the performance you require, and then only certain applications can use multiple cpus, or take advantage of multiple cpus.
SQL is one of these applications.
With your dual processor, quad core server, you will have a total of 8 cores that can be allocated to the VM as 1 vCPU.
1 vCPU is equal to 1 core on the physical host, or can be, it could be the same core for the duration of the VM process, or it could be shifted depending upon loading on the host, this is performed by the hypervisor.