March 23, 2015 at 7:18 pm
This is totally confusing to me. Can someone shed some light on this? I purchased a new server to install Hyper-v 2012R2 Datacenter Edition. I want to virtualize an already purchased 2 processor license of SQL Server 2008R2. The new server has the following specs:
4 Processors
10 cores/processor
Hyper threading is enabled
How may cores am I licensed to have running on the virtual machine?
Can someone explain the math, as I have been searching the Internet
and yet to find an explanation I can understand...
TIA
- Joe
March 24, 2015 at 3:19 pm
I think it would depend on the terms of the licensing model you purchased under.
What version of SQL 2008 R2 did you purchase, when did you purchase it and whom did you purchase it from?
Here's the quick guide for 2008 R2
March 24, 2015 at 3:29 pm
Quick thought, if the license was bought under the Processor (SQL Server 2008 R2 and earlier) then the core count is (almost) irrelevant. Theoretically you could have as many cores on the VM as on the actual CPUs have. Would be interesting to have an expert's opinion on how this maps to NUMA architecture.
😎
Guess the point is that if you have a processor license / socket license then the hardware is marking the upgrade path, not the software.
March 24, 2015 at 3:47 pm
Eirikur Eiriksson (3/24/2015)
Quick thought, if the license was bought under the Processor (SQL Server 2008 R2 and earlier) then the core count is (almost) irrelevant. Theoretically you could have as many cores on the VM as on the actual CPUs have. Would be interesting to have an expert's opinion on how this maps to NUMA architecture.😎
Guess the point is that if you have a processor license / socket license then the hardware is marking the upgrade path, not the software.
It's on page 3 of the pdf. Assuming they bought 2008 R2 under the 2008 R2 license model.
March 25, 2015 at 8:02 am
Hi guys,
Thanks for the feedback. Its a Standard (Microsoft Open) license of SQL Server 2008R2 purchased back in 2012. As stated earlier, we purchased two processor licenses at the time.
I was chatting with someone yesterday regarding this, and their opinion was that I could run up to two VM's running SQL Server 2008R2 with up to 10 cores per VM. So, each processor license could have a separate VM running a maximum # or cores as one of the physical processors have. Or, we could run one VM with up to 20 cores - as long as the number of VM's running SQL Server didn't exceed the number of processor licenses purchases, and as long as the # of cores allocated to these VM's didn't exceed the total number of cores available from two physical processors...
Does this sound correct?
Thanks,
- Joe
March 25, 2015 at 8:24 am
You may want to clarify with your vendor (or microsoft), but it sounds like you may be under the 2012 licensing model, which came into effect on April 1st 2012, this means you can use 2 virtual cores without hyperthreading for standard edition.
March 25, 2015 at 8:40 am
I just checked the purchase order and the date was February 15th, 2012. Does that change the licensing model that this falls under?
March 25, 2015 at 8:57 am
According to page 3 of the licensing quick reference if you have datacenter edition of Sql Server (not Windows Server) you can run unlimited. With Enterprise you can run 4 Operating system environments with Sql Server installed.
In the case of SQL Server 2008 R2 Standard, SQL Server 2008 R2 Workgroup, and SQL Server 2008 R2 Web, if you license all of the physical processors you may run the software in the physical OSE only. In order to run the software in virtual OSEs, you will need to license each virtual processor individually as described below:
For any virtual OSE, you can calculate the number of Per Processor Licenses required for the SQL Server edition that you are licensing by dividing data point A (number of virtual processors supporting the virtual OSE) by data point B (# of cores [if hyperthreading is turned off] or threads [if hyperthreading is turned on] per physical processor). If the result is not a whole number, round up to the next whole number.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply