Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2012 Ent Server+Cal to PER CORE - reinstall or SKU Upgrade? Expand / Collapse
Author
Message
Posted Thursday, February 13, 2014 7:11 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 4:57 AM
Points: 875, Visits: 1,760
In the near future I will have to upgrade an installation of SQL 2012 Ent.
Currnetly its under Server+Cal meaning we can only use a max of 20 cores.

We will be upgrading to PER CORE.

My question is:

Do I need to do a full uninstall and reinstall, or will a SKU Upgrade work here?
Post #1541178
Posted Friday, February 14, 2014 6:54 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 6:20 PM
Points: 1,146, Visits: 6,244
Haven't done this before, but it looks like it is supported.
See TechNet for details.
Under Upgrade How to Topics, you will see more details.
Post #1541581
Posted Monday, February 17, 2014 3:33 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, April 14, 2014 3:21 AM
Points: 2,797, Visits: 3,079
SQL 2012 Enterprise is only licensed by Core. If you think you are using CAL licenses with EE then you may not be correctly licensed.

SQL 2013 BI and SQL 2012 Standard can be licensed by CAL, but with Enterprise the only valid method is by Core. It may well be the same situation with SQL 2014.

If you are upgrading from Standard or BI to Enterprise then there is a simple process (see BOL) where you enter your new license key and restart SQL Server.

If you are already licensed by Core and have licences for fewer cores than are visible on Windows then you should use Processor Affinity within SQL Server to remain within your license terms. If you buy more core licences you only have to change your processor affinity to take advantage of the new licences.

If you are not certain of your license situation then my advice is to contact your license reseller.


Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 25 March 2014: now over 28,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1542023
Posted Monday, February 17, 2014 4:36 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 6:20 PM
Points: 1,146, Visits: 6,244
EdVassie (2/17/2014)
SQL 2012 Enterprise is only licensed by Core. If you think you are using CAL licenses with EE then you may not be correctly licensed.

SQL 2013 BI and SQL 2012 Standard can be licensed by CAL, but with Enterprise the only valid method is by Core. It may well be the same situation with SQL 2014.

If you are upgrading from Standard or BI to Enterprise then there is a simple process (see BOL) where you enter your new license key and restart SQL Server.

If you are already licensed by Core and have licences for fewer cores than are visible on Windows then you should use Processor Affinity within SQL Server to remain within your license terms. If you buy more core licences you only have to change your processor affinity to take advantage of the new licences.

If you are not certain of your license situation then my advice is to contact your license reseller.


My assumption is they have SA and were running 2008 R2 EE previously.
There is a grandfathering that allows this.
Core assumes 4 cores per processor.
If you plan on using Processor Affinity - check out and verify licensing implications, especially in a virtual environment.
And also test the performance, especially on a machine with NUMA architecture.
Post #1542040
Posted Monday, February 17, 2014 8:26 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 4:57 AM
Points: 875, Visits: 1,760
Spot on Greg, granfathering has allowed us to continue using Server+Cal.
Post #1542158
Posted Monday, February 17, 2014 1:42 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, April 14, 2014 3:21 AM
Points: 2,797, Visits: 3,079
If your CAL licences are valid and you are changing to Core licensing, then you may not need to do anything within SQL Server.

If your core licenses are for less cores than shown in Windows, then you need to do is to set processor affinity within SQL Server for the number of core licenses you hold.


Original author: SQL Server FineBuild 1-click install and best practice configuration of SQL Server 2014, 2012, 2008 R2, 2008 and 2005. 25 March 2014: now over 28,000 downloads.
Disclaimer: All information provided is a personal opinion that may not match reality.
Concept: "Pizza Apartheid" - the discrimination that separates those who earn enough in one day to buy a pizza if they want one, from those who can not.
Post #1542273
Posted Monday, February 17, 2014 6:55 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 6:20 PM
Points: 1,146, Visits: 6,244
EdVassie (2/17/2014)
If your CAL licences are valid and you are changing to Core licensing, then you may not need to do anything within SQL Server.

If your core licenses are for less cores than shown in Windows, then you need to do is to set processor affinity within SQL Server for the number of core licenses you hold.


Maybe both of you might be interested in this.
I would be inclined to either true up on cores, or consider hardware to match the licensing if possible.
Even memory on NUMA architecture needs to be thought out.
Just tossing in RAM chips to hit a number may not work as expected.
Post #1542329
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse