Review Microsoft SQL Server licensing and pricing to find the perfect edition for your database xbffug.meing model: Per core. SQL Server is offered in two main editions to accommodate the unique feature, performance and price requirements of organizations and individuals: Enterprise. Jun 24, - When licensing SQL Server Standard under the Server + CAL option, customers must assign a license to the physical server hosting any operating system environment (OSE) running SQL Server and acquire a SQL Server CAL for each user or device that accesses the server.
The purpose of this post is to cut through that complexity at an introductory level and then delve deeper in future posts. The previous release of SQL Server was commercially available in four editions: Enterprise edition Standard edition Developer The key difference here being that the licensing and product function of Business Intelligence edition has been absorbed into the Enterprise edition. SQL Server Express is available as a free download from Microsoft, but it must be noted there are limitations on its supported system requirements. For an overview of the available editions and supported scale of SQL Server, click here. How are SQL Server licenses sold? The software licensing options remains the same for SQL Server as previously available e. Table 1: The major benefit of this option is that there is no requirement to try to quantify the number of users or devices accessing the SQL Server, be that direct or via indirect means multiplexing. When running SQL Server in a physical environment, licenses must be assigned to all of the physical cores on the server.
Link Copied! Microsoft SQL Server is a common backend for many applications, whether it is for relational database needs to business intelligence and beyond. Where applicable, supportability and its effect on licensing will be addressed. Click on each of the links for the relevant licensing information for each respective OS. Microsoft also publishes a shorter data sheet. These are always the basis for any conversation with a Microsoft licensing professional. The rest of this section assumes the following: For purposes of licensing in context of this post, a VM and a container will be considered the same.
There are other components such as Analysis Services, Integration Services, and Reporting Services which may also require a separate license from SQL Server if they are running independently of the database engine.
Those will not be addressed. There are tools under the SQL Server umbrella. Some, but not all, are free. An example of tools that are not free are the ones for Business Intelligence.
If the goal is to deploy an older version of SQL Server, the license purchased and licensing terms are for the latest version of SQL Server and you get rights to deploy the target version. Cores are sold in packs of two. Each VM can be licensed individually, or entire hosts can be licensed. Which method you choose depends on how much SQL Server that will be deployed. If the OS referred to as an operating system environment, or OSE, in the Microsoft licensing documentation can see eight cores, you need to account for eight cores worth of SQL Server licensing.
The VM must meet the minimum of four cores for licensing. Those additional two cores purchased cannot be assigned to or used by another VM. Whether you deploy one instance per VM or more than one depends on many factors outside the scope of this blog. There are quite a few benefits to SA, one of which will be covered in the next section. This means that you are manually keeping track of licenses and how many cores are available.
For example, if you have a server with 32 cores with each core assigned a SQL Server Enterprise Edition license, you can deploy any legal combination of SQL Server VMs that totals up to the 32 cores available as long as you do not exceed the 32 licensed cores.
If you vMotion a VM where all the cores will be in use or the VMs running on that server will exceed the number of licensed cores for example, you have 32 licensed cores for SQL Server, but moving the VM brings you up to 36 , you will need to buy the appropriate amount of two packs to cover those cores. There is one way to cover you in this case: SA allows you to overcommit vCPU resources, SA has a benefit called Unlimited Virtualization which allows you to exceed the number of physical processors and deploy unlimited VMs with unlimited vCPUs and not have to worry about things like minimum core counts or how a vCPU or vCore is presented behind the scenes at the hypervisor.
What is meant by this? The Unlimited Virtualization benefit of SA also matters if hyperthreading is used. For physical implementations of SQL Server, hyperthreading does not affect the number core licenses. This is not true for virtualized SQL Server deployments. Unlimited covers all of this, and thus, SA should be considered in these cases.
If you are licensing per VM, this allows that VM to be moved and reassigned to another host more frequently than once every 90 days. A VM that is licensed on its own can be moved from Host A to B with vMotion, but if you do it more frequently than 90 days, you will need this benefit of SA. See the example in the next section for more information on maintenance. As mentioned in the previous section, Software Assurance is not only recommended, but in some cases, may be required depending on your scenario with regards to SQL Server availability.
This allows one of the VMs functioning as a standby server in a particular AG or FCI configuration that also has no active use to not require a license. This means that If you have an existing on premises vSphere deployment but want to extend it to VMWare Cloud on AWS for disaster recovery, all VMs or possibly hosts participating in that configuration would need to be licensed.
All examples in this section are based on supported configurations of SQL Server on any VMware deployment — on premises or in the cloud. This is shown in Figure 1. Figure 1. SA would benefit the deployment because of the aforementioned benefits to allow the VM in Region 2 to function as a standby with no additional licensing cost if the VMs are all located in the same Server Farm.
Server Farm means a single data center or two data centers each physically located either in time zones not more than four hours apart, or within the EU or EFTA. The other instance must not be running any live workloads. Microsoft considers a live workload tasks such as using a replica for readable queries, backing up from an AG secondary replica, and running database consistency checks to be a live workload.
No active use also means there are no other databases receiving requests and outside of receiving transactions from one or more AGs, nothing else is happening. In the case of the latter, even if SA has been purchased, both VMs would need to be licensed no matter what the usage or not is of the secondary replica. There is no SA benefit when spanning on premises and VMware Cloud on AWS, so at a minimum, the primary replica on premises and the secondary replica in the cloud must be fully licensed.
The SA benefit may or may not apply to the secondary replica on premises depending on if it has active use or not, such as for readable queries. Figure 2. Assume that there is enough SQL Server usage that per-host is the most cost-effective licensing scheme. In this example, all five hosts including the maintenance node would need to be licensed. The maintenance node comes into play when a host is designated for updates. Behind the scenes, another host will be added to the vSphere cluster and VMs from the host will automatically be moved via vMotion to that new host or one of the others in the VMware Cloud on AWS configuration.
This creates a zero-downtime scenario for the hosts which is a big benefit. However, there are two challenges: There is currently no mechanism to control where a VM is hosted; and There is no way to control when the maintenance will occur Figure 3. Similar to the previous example with the maintenance node, if the disaster recovery is brought live, that VM needs to be licensed. It also would be considered a hybrid configuration since it spans on premises and the public cloud.
Part of the puzzle is ensuring that SQL Server is licensed properly for the intended configuration s. Products Featured.