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
Licensing Scenario - Virtual Environmentwith License MobilityCustomer Scenario : Customer IT Infrastructure has 2 physical server – each has 4 processors with 4cores. On top of the 2 physical servers the customer has built five virtual Machines with differentnumber of virtual cores assigned to them. Customer wants SQL Server 2014 to be executed onVMs. Customer wants license mobility to be available for all the VMs. How should they license SQLServer 2014 for such requirements ?Option 1 – Based on Individual Virtual MachinesVM1VM2VM3VM4VM5 4 2 4 4 6VCoresVCoresVCoresVCoresVCores 2 2 2 2 3x 2-Corex 2-Corex 2-Corex 2-Corex al number of licenses 2 2 2 2 3 11 (2-core pack) licenses with Software Assurance License Mobility* Minimum of 4 cores to be licensed per VMLicensing by individual Virtual MachineVM 1VM 2VM 3VM 4VM 5Licensing by individual Virtual Machine:Available for Standard and Enterprise Edition
Licensing Scenario - Virtual Environmentwith License MobilityCustomer Scenario : Customer IT Infrastructure has 2 physical server – each has 4 processors with 4cores. On top of the 2 physical servers the customer has built five virtual Machines with differentnumber of virtual cores assigned to them. Customer wants SQL Server 2014 to be executed onVMs. Customer wants license mobility to be available for all the VMs. How should they license SQLServer 2014 for such requirements ?Option 2 – with unlimited VirtualizationTwo Server with 4 Processor (each 4 Cores) Total 8 Processor, each 4 Cores 16 x 2-Core-Licenses with Software Assurance License Mobility and ability to run an unlimitednumber of VMs with SQL on topLicensing for Unlimited VirtualizationVM 1VM 2VM 3VM 4VM 5Licensing for Maximum Virtualization:Available for Enterprise Edition only with active SA
Transition SQL Per Processor to Core BasedThe number of core licenses a customer is eligible to renew is based on the edition of SQL Server currentlylicensed and the number of cores in use when SA coverage expires.Transition from Processor Licenses to Core LicensesProcessor Based ModelCore Based License ModelQualified perpetual license under SAEligible to renew into minimum number ofcoresSQL Server Datacenter Edition8 SQL Server Enterprise EditionSQL Server Enterprise Edition4 SQL Server Enterprise EditionSQL Server Standard Edition4 SQL Server Standard EditionSQL Server Workgroup Edition4 SQL Server Standard EditionSQL Server Web Edition (non-SPLA) processorlicenses4 SQL Server Standard EditionThis are the minimum license customers receive. If they want even more licenses, they should do self inventory of the current licenses and claim extra licenses from Microsoft.
SQL Server 2014 (Core) – Fail-Over ServersThe passive secondary server used for failover support does not need to beseparately licensed for SQL Server.Terms to utilize this beneift:Fail-Over ScenarioActive ServerwithSALicensed Serverwith SA coveragePassive ServerPick UpUse only forfail-overSupport!No separate SQL LicenserequiredIn case the Active Server fails, its processing willbe picked up and continued by the Passive Server.Ø The passive secondary server used for failoversupport is truly passive and not performing anyadditional “work”.Ø The active Server must have active SoftwareAssurance coverage.Ø The number of physical cores on the passiveserver must not exceed the number of cores onthe licensed server if it is licenses based onphysical coresØ The number of Hardware Threads used in theseparate OSE must not exceed the number ofThreads used in the OSE in which the activeRunning Instances are used.
Value Engagement SQL Server workload
Value Engagement SQL Server workloadData Collection: Data requirements for a Baseline includes: Completed inventory of existing IT infrastructure andenvironment including on-premises, cloud, andoutsourced installationsSoftware entitlement, deployment, and retirementrecordsA nalysis: Analysis specific to a Baseline includes: Reconciliation analysis between license entitlementsand deployment data A SAM Optimization Model maturity assessment andrecommendations at each stage of the model Microsoft license agreements with recommendationsfor license consolidation and reassignment suggestions Microsoft SAM Assessment Report questions Information related to the maturity level of thecustomer ’s SAM policies, procedures and practices Identification of products that are unused or underutilized Information on current management and inventory tools Recommendations on repeatable, simplified inventorycollection
Value Engagement SQL Server workloadDeployment considerationsLicensing implicationsAre there opportunities to identify and consolidate oroptimize workloads to avoid unnecessary costs?Do you have the right licenses to fit the customer’sbusiness needs and strategies?What version of SQL Server is running and what is preventingus from migrating to a more recent version?How does Virtualization impact licensing?Would moving workloads to the cloud provide deploymentand management benefits?What are relevant Software Assurance (SA) benefits? Can thecustomer leveraging new version rights through SA?Are development and production environments isolated?Are there opportunities to improve the inventory processand SAM policies to support optimal licensing?Are deployment and management policies needed to ensureproper governance?Is the customer taking full advantage of theirinvestment in SQL licenses?
What is Microsoft Azure?“Microsoft Azure is an open and flexible cloudplatform that enables you to quickly build, deploy andmanage applications across a global network ofMicrosoft-managed datacenters.”Traffic ManagerBizTalk ServicesCacheActive DirectorySQL ReportingVirtual MachinesData TransfersMulti-Factor AuthenticationCloud ServicesBackupMobile ServicesNotification HubsWeb SitesStorageVirtual NetworkServices BusMedia ServicesHDInsightSQL DatabaseHyper-V Recovery Manager
Microsoft Azure ServicesBuild, deploy and manage applications across a global network of Microsoft-managed datacenters.qqqqqVirtual MachinesService FabricRemote AppCloud ServicesBatchWeb & MobileData & StorageComputeqqqqqqqqStorageSQL DatabaseStorSimpleDocumentDBAzure SearchSQL Data warehouseRedis CacheDocument DBqqqqqqqqApp ServiceWeb AppsMobile AppsLogic AppsAPI AppsAPI ManagementNotification HubsMobile ManagementNetworkqqqqqqqExpressRouteVirtual NetworkTraffic ManagerLoad BalancerDNSVPN GatewayApplication GatewayServices Overview 13 th Jan 2016SupportMicrosoft Azure Services Overview and Descriptions: http://azure.microsoft.com
Microsoft Azure Services Cont. .Build, deploy and manage applications across a global network of Microsoft-managed datacenters.qqqqqqqqData lake AnalyticsData Lake StoreHD InsightMachine LearningStream AnalyticsData FactorySQL Data WarehouseData CatalogMedia and CDNInternet of ThingsAnalyticsqqqqqqIoT SuiteIoT HubEvent HubsStream AnalyticsMachine LearningNotification HubsMedia ServicesEncodingAzure Media PlayerAzure Media IndexerContent ProtectionLive and On DemandStreamingq CDNqqqqqqHybrid IntegrationqqqqBiztalk servicesService BusBackupSite RecoveryServices Overview 13 th Jan 2016SupportMicrosoft Azure Services Overview and Descriptions: http://azure.microsoft.com
Microsoft Azure Services Cont. .Build, deploy and manage applications across a global network of Microsoft-managed datacenters.Identity and AccessManagementqqqqAzure Active DirectoryAzure Active Directory B2CAzure AD Domain ServicesMulti-Factor AuthenticationDeveloper Servicesq Visual Studio Team Servicesq Azure Dev Test labsq Visual Studio Application InsightsManagementqqqqqqMicrosoft Azure Preview PortalSchedulerAutomationOperational InsightsKey VaultSecurity CenterServices Overview 13 th Jan 2016SupportMicrosoft Azure Services Overview and Descriptions: http://azure.microsoft.com
How to purchase Microsoft Azure? (1/2)Microsoft Azure get charged based on the use ofeach individual service.Measuring Methods:Each service has its own unique meter with a unique charge structure:Hours, Gigabytes, Users, Volume of Content, Instances, and .
How to purchase Windows Azure? (2/2)Two Licensing OptionsMOSPVolume LicensingPay-as-you-go:q No commitmentq Pay for what you use eachmonthOpen Programs:q Purchase Azure Creditsthrough one of theavailable Open Programs:OL, OV, OVSMicrosoft Online Services ProgramEnterprise Agreement:q Purchase Azure MonetaryCommitment through oneof the availableEnrollments EA, EAS, SCEor EWA
Add Microsoft Azure to Enterprise AgreementAdd Microsoft Azure at any time to the Enrollment by making anupfront monetary commitmentUpfront MonetaryCommitmentConsume any numberof Windows Azureservices up to themonetary commitmentPay annually if no morethan 50% beyond thecommitment for theadditional used servicesPay quarterly if morethan 50% beyond thecommitment for theadditional used servicesMonetary Commitment means the total monetary amount a customer commits to pay over the term of the subscription for its use of the Windows Azure Services.
Monetary Commitment through EnterpriseAgreementMonetary Commitment means the total monetary amount acustomer commits to pay over the term of the subscriptionfor its use of the Windows Azure Services.Customers may increase their MonetaryCommitment at any time by placingadditional orders.Customers must consume their AllocatedAnnual Commitment by the last day of themonth preceding enrollment anniversaryeach year. Any unused portion of theAllocated Annual Commitment will not carryover and will be forfeited.Upfront MonetaryCommitmentConsume any numberof Windows Azureservices up to themonetary commitment
Azure Prices in Enterprise Agreement (1/2)Through the Enterprise Agreement commitment to Microsoft,enterprise customers will get best Azure prices based on theirinfrastructure spend.EA Price CLevelD5%5%5%5%3 to 12% (compared to MOSP)on most Azure ServicesSCE Price AdvantageAnother 5 % off the EA level pricing
Azure Prices in Enterprise Agreement (2/2)Price Trend / Changes to EA DiscountMS FY 14MS FY 1527-36%3-12 %3-12%Discountq Microsoft dropped MOSPlist prices to matchAmazon’s pricing.q EA Pricing kept on samelevel as it was.q Discounts can varydepending on the service.q Some services even 0%q Most services new 3-12%q Some services still 27-36
Microsoft Azure through MPSAConsumption-based servicesMPSA Paid for quarterly, in arrears Most services are available* Managed through the Azure Enterprise PortalUser-licensed services All services are available* Microsoft Azure Backup, Microsoft Azure Site Recovery are not currently availableAzure Consumption Services in the MPSA From July 2015, customers can purchase Azure consumption services through the MPSACustomers pay for actual usage, quarterly in arrearsOptionsØØØCustomers can choose to set up multiple Azure Enrolments with a Purchasing AccountAn Enrolment is associated within a single partnerEnrolments may be further broken out into Accounts and Subscription s base d on bu siness nee ds and how Azure services areintended to be used
Windows Azure Support OptionsSupport emierBilling & Subscription ManagementüüüüüCommunity ForumsüüüüüService DashboardüüüüüWeb Incident Submission-üüüüUnlimited Break/Fix (24x7)-üüüüFastest Response Time- 8 hours 2 hours 1 hour 15 minPhone Support (Call Backs)--3/MonthUnlimitedUnlimitedService Delivery Management---PooledAssignedPriority Handling---üüEscalation Phone Line---üüAdvisory Support---LimitedOnsite Services----üDeveloper Mentoring----üFull
Windows Azure LinksWindows Azure Services Overviewhttp://azure.microsoft.com/Windows Azure Purchase indows Azure Health Dashboard with Auto refresh every 10 minhttp://azure.microsoft.com/en-us/status/
SQL Server Standard SQL Server Busness Intelgence SQL Server Enterprise only SA renewal With the introductionof SQL Server 2012, Enterprise Edition was removed fromthe Server CAL model and new