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


SQL 2008 R2 Standard Edition license requirements for a Virtual Server


SQL 2008 R2 Standard Edition license requirements for a Virtual Server

Author
Message
Stueyd
Stueyd
Mr or Mrs. 500
Mr or Mrs. 500 (567 reputation)Mr or Mrs. 500 (567 reputation)Mr or Mrs. 500 (567 reputation)Mr or Mrs. 500 (567 reputation)Mr or Mrs. 500 (567 reputation)Mr or Mrs. 500 (567 reputation)Mr or Mrs. 500 (567 reputation)Mr or Mrs. 500 (567 reputation)

Group: General Forum Members
Points: 567 Visits: 313
Hi All,

I've read several things on the web today and got myself totally confused.
Can someone explain to me how I should license the following:

We have a VMWare ESX 2 node cluster and each physical server has 2 x 12 core CPUs.
We've been given a Virtual Server on this which has 2 virtual CPUs and we've installed SQL Server 2008 R2 Standard Edition.
In order to be correctly licensed, how many CPU licenses would we need to buy?

If I understand the last MS doc I read correctly, the formula is # of OSE virtual CPUs divided by the # of physical cores per processor and round up.
So 2 / 12 = 1 CPU license.

Is this correct ?

The document I read also states "You may move running instances of SQL Server 2008 R2 Enterprise or Datacenter as needed across servers within a server farm. (There is no 90 day minimum period before reassignment.)"

What about Standard Edition ?
If there's a problem with one of the nodes and vMotion decides to shift SQL to the other node in the server farm are we still covered with Standard Edition ?



Stueyd
Stueyd
Mr or Mrs. 500
Mr or Mrs. 500 (567 reputation)Mr or Mrs. 500 (567 reputation)Mr or Mrs. 500 (567 reputation)Mr or Mrs. 500 (567 reputation)Mr or Mrs. 500 (567 reputation)Mr or Mrs. 500 (567 reputation)Mr or Mrs. 500 (567 reputation)Mr or Mrs. 500 (567 reputation)

Group: General Forum Members
Points: 567 Visits: 313
Bump.



jasona.work
jasona.work
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16286 Visits: 13116
Your best bet to get the best answer, is going to be to contact a Microsoft Licensing specialist. I'm presuming your using Volume Licensing, in which case here's the contact page: http://www.microsoft.com/Licensing/contact-us.aspx

Yes, MS Licensing is at least as difficult to understand the rules as SQL Server (maybe harder) which is why most everyone will shy away from providing an answer other than "call MS." It's way to easy to get the answer wrong...

Jason
EdVassie
EdVassie
SSC-Insane
SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)SSC-Insane (23K reputation)

Group: General Forum Members
Points: 23244 Visits: 3916
My understanding is that for a virtual server, you only need a licence for the number of cores that will be running SQL Server.

By default, SQL Server is set to use all the cores visible to Windows, but you can set processor affinity to use fewer cores. You only need to license the cores you are using.

Some examples:

If you have a host server with 8 cores and define 8 guests each of which are allocated use of 2 cores and you install SQL Server on all these guests and allow them to use all cores visible in Windows, and you license each guest separately, you need to license for 16 cores. However, if you get a SQL Server Data Centre license for this host, then you only need to license for 8 cores.

If you have a host server with 8 cores and you define one guest which is allocated use of all 8 cores and you install SQL Server and allow it to only use 4 cores, you only need to license for 4 cores.

If you have a physical server with 8 cores and you install SQL Server and allow it to only use 4 cores, because this is a physical server you must license for all 8 cores.

If you want your management to sleep well at night knowing they have a valid license for all the SQL Server cores you are using, then follow jasona's advice and get help from a Microsoft Licensing specialist.

Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005. 14 Mar 2017: now over 40,000 downloads.Disclaimer: All information provided is a personal opinion that may not match reality.Quote: When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist. - Archbishop Hélder Câmara
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