SQL Services News

Different SQL 2012 Enterprise Editions

01 Aug 2016
If you run the following check on your schedulers:
select * from sys.dm_os_schedulers
You should see them all Online, either Visible for user processes or hidden online for internal database engine processes. Unless you are using Affinity mask you should not see any as offline if you are using Enterprise Edition – right?
With SQL 2012 the licensing changes from a processor to a core model. This led to a need for two editions of Enterprise edition – one for people with Enterprise agreements to transition their servers, and one for new core based installations.
This led to some confusion as the Enterprise Edition designed for upgrading your current Server+CAL licensing from 2008 R2 to 2012 has a 20 core limit(or 40 with hyperthreading). If you are running the Enterprise Edition of 2012 and if you have more than 20 cores, we recommend you take a peak at sys.dm_os_schedulers to make sure you are getting all of what you are paying for.
This Hot Tip was provided by Rob, one of our Nelson based SQL Server consultants. If you require any assistance, please contact SQL Services Limited.
Click here to return to the news items...

Microsoft Gold Data, Silver BI partner © Copyright SQL Services Limited 2019. For information on how SQL Services processes personal data please refer to our group privacy statement on our Group Website URL Privacy Statement Oracle Partner Logo