Microsoft Product Licensing – SQL Server

Microsoft Product Licensing – SQL ServerBeat Weissenberger (MS Schweiz)Alexander Egli (MS Schweiz)Detlef Werner (SoftwareONE)

Copyrights & WarrantiesThis document contains proprietary information that is protected by copyright.SoftwareONE reserves all rights thereto.SoftwareONE shall not be liable for possible errors in this document. Liability for damages directly andindirectly associated with the supply or use of this document is excluded as far as legally permissible.The information presented herein is intended exclusively as a guide offered by SoftwareONE. Thepublishers product use rights, agreement terms and conditions and other definitions prevail over theinformation provided herein. The content must not be copied, reproduced, passed to third parties or usedfor any other purposes without written permission of SoftwareONE.Copyright 2016 by SoftwareONE

Agenda1Evolution of SQL Server Licensing2Transition from processor based to core licensing3Hybride Scenarios

SQL Server Support LifeCycle

SQL Meilensteine1988Microsoft erwirbt die Lizenz von Sybase – Unix basierend1994SQL Server 4.2 - Windows NT 3.11996SQL Server 6.5 – Windows NT à Full, VUP, PUP, Upg1998SQL Server 7.0 Replication – Windows NT à Full, VUP, PUP, Upg2000SQL Server 2000 Log Shipping – Windows Server 2000/NT à L, UA, L/SA, SA2005SQL Server 2005 Mirroring – Windows Server 2003R2 à L, L/SA, SA2008SQL Server 2008 – Windows Server 2008 à L, L/SA, SA2010SQL Server 2008R2 – Windows Server 2008R2 à L, L/SA, SA2012SQL Server 2012 – Windows Server 2012 à L, L/SA, SA2014SQL Server 2014 – Windows Server 2012R2 à L, L/SA, SA

SQL Server 2008 R2 Editions

SQL Server 2008 R2 License ModelPer Processor Licensing Microsoft offers a Per Processor licensing model to help alleviate complexity.When licensing SQL Server software under the Per Processor model, you do not need to purchase additional CALs;it includes access for an unlimited number of users or devices to connect from either inside or outside the firewall.Per Processor Licenses for SQL Server 2008 R2 are available for Datacenter, Enterprise, Standard, Workgroup,Web, and Parallel Data Warehouse editions.

SQL Server 2008 R2 License ModelServer/CAL Licensing When licensing SQL Server software under the Server/CAL model, you purchase aServer License for the server and a Client Access License (CAL) for each device (Device CAL)and/or user (User CAL) accessing or using the services or functionality of SQL Server or any of itscomponents (e.g. Reporting Services). A CAL is not software; it is a legal document granting access.

SQL Server 2008 R2 MultiplexingA SQL Server CAL and Windows Server CAL are required for each distinct device or user that is connected to themultiplexing or pooling software or hardware front end:Manual transfer of data from employee to employee does not require a CAL for the receiving employee.

SQL Server 2008 R2 Virt. ScenariosLicensing for Virtualization Under the Per Processor Model The number of operating system environments (OSEs)in which you may run instances of SQL Server 2008 R2 under the Per Processor model depends upon the editionyou license and whether or not you license all of the physical processors with a Per Processor LicenseLicensing All Physical ProcessorsIf you license all of the physical processors on the server (one license per physical processor), you may run unlimitedinstances of the SQL Server software in the following number of OSEs (either physical or virtual):

SQL Server 2008 R2 Virt. ScenariosLicensing a Portion of the Physical ProcessorsIf you license all of the physical processors on the server (one license per physical processor), you may run unlimitedinstances of the SQL Server software in the following number of OSEs (either physical or virtual):In order to run the software in virtual OSEs, you will need to license each virtual processor individually as desc. below.SQL Server 2008 R2 Standard, SQL Server 2008 R2 Workgroup, and SQL Server 2008 R2 Web

SQL 2008R2 License grantsIf customers do not perform the self-inventory, they will receive a value of 4 core licenses for each Standard andEnterprise Edition processor and 8 EE core licenses per Datacenter Edition processor.

SQL 2008R2 License grantsCustomers should do this self-inventory (or SAM Project) using the Microsoft Assessment and Planning (MAP)Toolkit or other inventory tools and processes to accurately archive a time/date stamped inventory of hardwaretied to SQL Server installations:

Core Based Licensing – SQL 2014

Main Editions – SQL 2008 R2, 2012 and 2014StandardEnterpriseDatacenterStandardBusiness IntelligenceEnterpriseSQL Server 2014 StandardSQL Server 2014 BusinessIntelligenceSQL Server 2014Enterprise

Overview SQL Server 2012 & 2014 – Main EditionsSQL Server BusinessIntelligenceSQL Server StandardStandard continues to offer basic database,reporting and analytics capabilitiesSQL Server EnterpriseBusiness Intelligencefor Premium SelfService and Corporate Business IntelligenceEnterprise for Mission Critical & ApplicationsData Warehousing Rapid data discovery with Power ViewCorporate and scalable reporting and analyticsData Quality Services and Master DataServicesIncludes Standard edition’s capabilities Advanced high availability with Always OnHigh performance data warehousing withColumnStoreMaximum virtualization (with SoftwareAssurance)Includes Business Intelligence edition’scapabilities

Main Editions SQL 2014 - Feature comparisonFeaturesEnterpriseBIStandardOS Max16 cores-DBOS Max-S&RS ¹16 coresProgrammability (T-SQL, data types, FileTable)XXXManageability (SQL Server Management Studio, policy-based management)XXXBasic high availability ²XXXBasic security (Separation of duties, basic auditing)XXXBasic OLTPXXXBasic corporate BI (Reporting, analytics, multidimensional semantic model, data mining)XXXBasic data integration (Built-in data connectors, designer transforms)XXXSelf-service business intelligence (Alerting, Power View, Power Pivot for SharePoint Server)XXAdvanced corporate BI (Tabular BI semantic model, advanced analytics and reporting, in-memory analyticsengine, advanced data mining)XXEnterprise data management (Data Quality Services, Master Data Services)XXAdvanced data integration (Fuzzy grouping and lookup, change data capture)XAdvanced security (SQL Server audit, transparent data encryption)XData warehousing (Updatable in-memory columnstore, compression, partitioning)XAdvanced high availability (AlwaysOn, multiple, active secondaries; multi-site, geo-clustering)XAdvanced transaction processing (In-memory OLTP)XMaximum number of cores¹Analysis Services & Reporting Services.² Basic includes log shipping, database mirroring, Windows Server Core support and two-node Failover Clustering.

SQL Server 2014 - Two Licensing ModelsMain EditionsServer CALCore-basedDescriptionBased on number ofUsers or DevicesBased oncomputing powerSQL ServerStandardSQL ServerBusiness IntelligenceSQL ServerEnterpriseonly SA renewalWith the introduction of SQL Server 2012, Enterprise Edition was removed from the Server CAL modeland new server licenses are no longer available. However, customers with active Software Assurancecoverage can continue to renew SA on Enterprise Edition and upgrade to SQL Server 2014You may run any number of instances of the server software in up to four OSEs on the licensed server at a time, provided that:(a) if you are running the software in a physical OSE, the OSE may access up to 20 physical cores at any time, and(b) if you are running the software in one or more virtual OSEs, that set of OSEs may access up to 20 hardware threads at any

Licensing for physical EnvironmentAvailable EditionsSQL Server SQL 2014 Standard Edition (SE) SQL 2014 Enterprise Edition (EE)Core-based Model2 Processors with 4 Cores 8 Cores 4 x 2-Core-Licenses1)License all of the physical cores on the hardwaremultiplied by the applicable Core Factor located here.2)A minimum of 4 core licenses is required for eachphysical processor on the server.3)Run any number of Instances in the Physical OSE on theLicensed Server

Core Factor – How to determine the correct number of Cores1) Count the total number of physical cores in the server.2) Multiply the number of cores by the appropriate core factorto determine the total number of licenses required for the server.NumberOf CoresMultiply withCore Factor Numberof LicensesSQL Server Core Factor TableProcessor TypeAll processors not mentioned belowAMD Processors 31XX, 32XX, 33XX, 41XX, 42XX, 43XX, 61XX, 62XX, 63XX SeriesProcessors with 6 or more coresCore Factor10.75Dual Core Processors2Single Core Processors4Click here to view the Core factor Table (Published April 2014)

Licensing Scenario - Physical EnvironmentCustomer Scenario : Customer has a dual processor server (each 4 cores) and want to purchaseSQL Server 2014 Core licenses to host a database application running in a physicalenvironment. How many Core licenses will they need to acquire for this server?Number of cores per physical processor 4Number of processors per server 2Total number of cores 8Number of licenses required 4 x 2-Core LicensesPhysical CoresPer Processor12468Core Licenserequired44468

Licensing Options for Virtual EnvironmentsSQL 2014 provides two options of licensing by using in virtualenvironmentsLicense byLicense forAvailable Products:Available ProductsIndividual Virtual MachinesSQL – Standard, EnterpriseUnlimited VirtualizationSQL - Enterprise Edition with SA(only WITH Software Assurance)By covering with Software Assurance you get the Flexibility of License Mobility:Move the licensed VMs from server to server or to hosters or the cloud

Licensing for virtual Enrionment – Individual VMAvailable EditionsSQL Server SQL 2014 Standard Edition (SE) SQL 2014 Enterprise Edition (EE)VM 1VM 2VM1 6 virtual cores 3 x 2-Core-LicensesVM2 2 virtual cores 2 x 2-Core-Licenses (min. 4)Core-based Model1)License the virtual cores in each virtual machinein which you run the software.2)There is a minimum of 4 core licenses requiredfor each virtual machine3)Run any number of Instances in any Virtual OSEfor which you have assigned the requirednumber of licenses.

Licensing for virtual Environment – Unlimited VirtualizationAvailable EditionSQL Server SQL 2014 Enterprise Edition (EE)with active Software AssuranceVMVMVMVMVMVMVMVMVM4 Processor with 2 Cores 8 x 2-Core License (min 4) Unlimited number of VMs if licensed with SACore-based Model1)License all the physical cores on the server (orserver farm) multiplied by the applicable CoreFactor located here.2)Run on the licensed server any number ofinstances of the software in any number ofphysical and/or virtual OSEs.Only as long as the SA coverage is active!

Licensing Scenario - Virtual EnvironmentCustomer Scenario : Customer has a physical server with 4 processors – each 4 cores. There are twovirtual machines built- a quad VCore VM and another dual VCore VM. Customer wants to deploySQL Server 2014 Core licenses to host the database application running on VMs. How many Corelicenses will they need to acquire ?VM 1VM1 4 virtual coresVM2 2 virtual coresNumber of VCores 6VM 2Number of licenses required 4 x 2-CoreLicenses (minimum of 4 cores per VM)Virtual Coresassigned per VM12468Core Licenserequired44468