Sql server 2012 licensing reference guide

Next SlideShares. You are reading a preview. Create your free account to continue reading. Sign Up. Upcoming SlideShare. Embed Size px. Start on. Show related SlideShares at end.

WordPress Shortcode. Share Email. Top clipped slide. Download Now Download Download to read offline. Mcts self paced training kit exam sql server - implementation and Aho hopcroft - estructura de datos y algoritmos p1.

Polimorfismo en java. T14 - Clases abstractas e interfaces. Clases abstractas. Related Books Free with a 30 day trial from Scribd. Related Audiobooks Free with a 30 day trial from Scribd. Elizabeth Howell. This guide does not supersede or replace any of the legal documentation covering SQL Server use rights.

This licensing guide is not a legal use rights document. Program specifications and business rules are subject to change. All rights reserved. This document is for informational purposes only. Microsoft provides this material solely for informational and marketing purposes.

Microsoft software is licensed not sold. The value and benefit gained through use of Microsoft software and services may vary by customer. Customers with questions about differences between this material and the agreements should contact their reseller or Microsoft account manager. Microsoft does not set final prices or payment terms for licenses acquired through resellers.

Final prices and payment terms are determined by agreement between the customer and its reseller. Eligibility for Software Assurance benefits varies by offering and region and is subject to change. The Terms and Conditions of your Volume License Agreement and the Terms and Conditions under which any specific Software Assurance benefits are offered will take precedence in the case of any conflict with the information provided here.

For eligibility criteria and current benefit program rules, see the Microsoft Product List. The new editions are offered in a straightforward, tiered model that creates greater consistency across the product editions, features and licensing.

Other specialty editions of SQL Server include Developer editions licensed for non-production use, the freely downloadable and distributable Compact and Express editions, and the next generation SQL Server Parallel Data Warehouse, which is available as an integrated appliance offering. For customers with as few as five users, Microsoft offers licensing programs to help reduce administrative overhead and software management costs, while enabling product licensing on an ongoing basis at considerable discounts.

The various licensing options enable customers to choose the program that works best for their management and operational needs. With the EAP, customers get the latest SQL Server and other Application Platform products across their organizations on new and existing deployments with lower up-front costs, and savings of up to 40 percent on new IT solutions.

Every edition may not be available in all channels or licensing programs in all regions. With SQL Server , Microsoft continues to offer customers a variety of licensing options aligned with how customers typically purchase specific workloads. However, for customers who cannot count users or require premium database capabilities, the way Microsoft licenses SQL Server for computing power is changing.

In the new computing-power based license model for SQL Server , the measure of computing power is shifting from physical processors to cores. Core-based licensing gives customers a more precise measure of computing power and a more consistent licensing metric, regardless of whether solutions are deployed on physical servers on-premise, or in virtual or cloud environments. The number of core licenses needed depends on whether customers are licensing the physical server or individual virtual operating system environments OSEs.

This figure depicts a physical server with two physical processors, each containing six physical cores Physical Server Physical Processors Physical Cores Physical Server A server is a physical hardware system capable of running server software. A hardware partition or blade is considered to be a separate physical hardware system.

Physical Processor A processor is generally a physical chip that resides in a physical socket of the hardware partition and contains one or more cores. Physical Core Each physical processor contains smaller processing units called physical cores. Some processors have two cores, some four, some six or eight, and so on.

The figure above shows an example of two physical processors with six cores each. Hardware Thread A hardware thread is either a physical core or a hyper-thread in a physical processor.

Physical Operating System Environment A physical operating system environment OSE is configured to run directly on a physical hardware system and is all or part of an operating system instance.

For detailed definitions of these and other key licensing terms, please refer to the Microsoft Volume Licensing PUR 8. Software partitioning does not reduce the number of core licenses required, except when licensing individual virtual machines VMs. The minimum number of licenses required for each processor on the server still applies. To determine and acquire the correct number of core licenses needed, customers must: 1.

Count the total number of physical cores in the server. The Open Value license is designed for small-to-medium organizations that have five or more desktop PCs. The agreement is designed to lower up-front costs for software and lasts for two years. The minimum license spend is for five licenses, but the program follows a pay-as-you-go model with the option to add or remove them at any time. The Select and Select Plus programs are designed for midsize organizations with a distributed infrastructure.

They support affiliate licensing and include Software Assurance. They have one differing feature - the Select license expires after three years, but the Select Plus license has no expiry date, allowing the organization to benefit from fixed pricing and favorable contractual terms beyond the initial contractual period. In all other feature areas, Select and Select Plus are identical.

The final group includes Software Assurance as standard. Features include volume pricing - significantly lower than for other agreements - inclusive SA, cloud service support, license management assistance, lower up-front costs and flexible subscriptions.

EA is the standard agreement where licensing needs are driven by the organization and can be thought of as a one-size-fits-all solution.

The type of licensing you will purchase will be dependent on the edition of SQL Server which you purchase, which will be dependent on the features you expect from SQL Server. SQL Server comes in the following editions:.

Each edition has limitations on the licensing models that can be used to purchase it. Please see my interpretation below, illustrating which licensing models can be used with which editions. The Express and Compact Editions are free, and do not require licenses. Microsoft also provides a table with this information in the document entitled 'SQL Server Licensing Reference Guide', which is linked to at the end of this tip. Follow the arrows in the diagram below from your desired edition of SQL Server or from your current licensing model to find which editions or licensing models are suitable for you:.

Each edition of SQL Server differs in features. For example, Developer Edition has all the features of Enterprise Edition, but cannot be used in a commercial environment. Standard Edition does not include features such as table partitioning, online index rebuilds or backup compression. Express Edition will handle databases up to 10GB in size only. Since the focus of this discussion is on licensing models rather than a blow-by-blow account of feature differences between editions, please see the More Links section for information on the different features of SQL Server and how they compare in order to make the best choice of edition for your organization's needs.

The document 'What's New in SQL Server ' has a good summary of new features and their availability between versions, while those of you familiar with these restrictions in R2 and below will note that most restrictions still apply. See below for Microsoft's one-page summary of the feature sets that come with Enterprise, Business Intelligence and Standard Editions note this is not a complete list :. For example, if your organization employs people, 20 of whom work in the Finance department which has two SQL Server installations on two separate servers, 2 server licenses and 20 CALs would be required.

Starting with , Microsoft recognized the shift onto core-based computing, where two or more cores are used for parallelism and better efficiency on production IT systems. Microsoft decided to capitalize on this and protect the licensing fees which would arguably suffer as focus shifted from increasing the number of processors to increasing the number of cores.

The new core-based system means each core used in a SQL Server installation must be licensed separately with some exceptions, see below. These licenses are sold in 'packs' of two and one pack of two is roughly equivalent in price to the older per-processor license. Thus, although more licenses are required and other factors such as price adjustment and inflation have affected the price , there may not be a significant difference to the overall price when relicensing for , depending on your circumstances.

Note that hyper threading is ignored for core licensing purposes when licensing physical servers. However - something called 'Core Factor' comes into play here. Core factor refers to the factor one must multiply by when determining the licenses required, depending on the type of processor one has.

AMD processors are licensed differently from Intel ones. And non-Intel, non-AMD processors are licensed differently still. Here are the rules:. Note that when ordering the licenses, you must divide the number of licenses by two to determine how many 'packs' to order. Don't order double the amount you need by accident! As you can see, this isn't an entirely fair model.

A four-core Intel processor requires 16 licenses even though performance-wise it will be thoroughly outstripped by two processors with two cores each, due to increased parallelism.

For this reason, in a single-core architecture, you may wish to make sacrifices with e. Microsoft stipulate that for those customers installing SQL Server in virtual environments, a core license is required for every virtual core in the virtual environment that is supported by one hardware thread this means physical processor core OR hyperthread.

Be very wary when using hyperthreading on physical machines that support VMs, as licensing costs can double despite having no additional physical computing power!

This means that if there exists a VM with multiple virtual cores, one license is required for each virtual core even if supported by fewer hardware threads than cores.

However, if multiple hardware threads are supporting fewer cores, one license is required for each hardware thread. Core factoring does not apply for VMs. There is a minimum four licenses required per VM regardless of VM cores. In example number 3 above, the VM is under provisioned against the physical machine so you may wish to add more VMs so that VM core licensing is appropriate to get better value for or even save money , or turn off hyperthreading, or go for maximum virtualization see below for more details to remove the need to license per core on each VM.

Note that physical licensing wins out over virtual licensing. Microsoft call this 'Licensing for Maximum Virtualization' and enables you to disregard your VM cores, so should you decide to have more VM cores than physical ones you will not necessarily be penalized.

So if you decide to physically license your cores even though you're running VMs, you will be able to run SQL Server in VMs up to a maximum number equal to the number of physical core licenses you hold. For example, if you have a large server with 8 processors, 6 cores per processor, you will require 48 core licenses.

First Step is Product Selection. Select the product by clicking on the product that you want e. Select the Language type as per your requirement. Provide the information for Program selection. If we need any guidance for Volume Licensing products and programs, we can use Guided Quotes which provides two options:. First step is Program Selection.

Select the your option and click on Next. Click Next. Email This BlogThis! James Zicrov August 9, at PM. Newer Post Older Post Home. Subscribe to: Post Comments Atom.