SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Virtualizing SQL Server 2008R2


Virtualizing SQL Server 2008R2

Author
Message
support 47509
support 47509
SSC-Enthusiastic
SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)

Group: General Forum Members
Points: 159 Visits: 6
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
benjamin.reyes
benjamin.reyes
SSCarpal Tunnel
SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)

Group: General Forum Members
Points: 4599 Visits: 2286
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

http://download.microsoft.com/download/2/7/0/270B6380-8B38-4268-8AD0-F480A139AB19/SQL2008R2_LicensingQuickReference-updated.pdf
Eirikur Eiriksson
Eirikur Eiriksson
SSC Guru
SSC Guru (161K reputation)SSC Guru (161K reputation)SSC Guru (161K reputation)SSC Guru (161K reputation)SSC Guru (161K reputation)SSC Guru (161K reputation)SSC Guru (161K reputation)SSC Guru (161K reputation)

Group: General Forum Members
Points: 161621 Visits: 23610
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.
Cool
Guess the point is that if you have a processor license / socket license then the hardware is marking the upgrade path, not the software.
benjamin.reyes
benjamin.reyes
SSCarpal Tunnel
SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)

Group: General Forum Members
Points: 4599 Visits: 2286
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.
Cool
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.
support 47509
support 47509
SSC-Enthusiastic
SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)

Group: General Forum Members
Points: 159 Visits: 6
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
benjamin.reyes
benjamin.reyes
SSCarpal Tunnel
SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)

Group: General Forum Members
Points: 4599 Visits: 2286
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.
support 47509
support 47509
SSC-Enthusiastic
SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)SSC-Enthusiastic (159 reputation)

Group: General Forum Members
Points: 159 Visits: 6
I just checked the purchase order and the date was February 15th, 2012. Does that change the licensing model that this falls under?
benjamin.reyes
benjamin.reyes
SSCarpal Tunnel
SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)SSCarpal Tunnel (4.6K reputation)

Group: General Forum Members
Points: 4599 Visits: 2286
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.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search