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 Server 2012 Licensing Question Expand / Collapse
Author
Message
Posted Wednesday, February 13, 2013 3:40 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 15, 2014 6:38 AM
Points: 155, Visits: 500
Hello - I'm hoping somebody can assist with a licensing question...

SQL Server 2012 Standard Edition with Server + CAL licensing is limited to a maximum of 16 cores.

If it was installed on a server with 20 cores and SQL was maxed out - would it use 100% CPU of 16 cores or would it run over more than 16 cores but with less than 100% CPU on each (to the equivalent of using 100% of 16 cores)?

Also, would the licence cost still be based on 16 cores or would it be charged for all 20 cores even though only 16 can be fully utilised by SQL?

Many thanks


Gavin.



Post #1419372
Posted Thursday, February 14, 2013 1:50 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 2:20 AM
Points: 5,231, Visits: 5,106
I thought the limit was 20 cores, not 16.

But if SQL can see 20 cores, but only use 16, you still need to licenses all 20 cores as it is what the server sees what needs to be licensed, not what it is using.





Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1419872
Posted Thursday, February 14, 2013 6:04 AM


SSCoach

SSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoachSSCoach

Group: General Forum Members
Last Login: Today @ 7:23 PM
Points: 15,737, Visits: 28,145
Always, always, always, contact Microsoft directly for licensing questions. It's a constantly shifting target. Plus you can negotiate deals. There's just no way a random stranger, even ones as informed as the people on this discussion group, can give you better information than what you're going to get from Microsoft. Not for licensing.

----------------------------------------------------
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood..." Theodore Roosevelt
The Scary DBA
Author of: SQL Server 2012 Query Performance Tuning
SQL Server 2008 Query Performance Tuning Distilled
and
SQL Server Execution Plans

Product Evangelist for Red Gate Software
Post #1420016
Posted Friday, February 22, 2013 7:38 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: 2 days ago @ 7:46 AM
Points: 47, Visits: 264
My Understanding was the limit is 20 cores. You also need to install the specific version of SQL 2012 Enterprise that still allows you to be under the Server + CAL agreement.

IF you are running that version, AND you have more than 20 cores, I believe SQL will ignore the additional cores entirely, they will not be utilized at all.
Post #1423063
Posted Monday, February 25, 2013 4:37 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, August 15, 2014 6:38 AM
Points: 155, Visits: 500
Many thanks for the information/confirmation and point taken, I will contact Microsoft directly regarding the license question.
Post #1423538
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse