


This Edition of SQL Server is free to use and distribute. Enterprise Edition supports CORE Based Licensing and does not support CAL based Licensing.1.Express Edition: The Standard Edition of Microsoft SQL Server 2016 supports both CAL based Licensing and CORE based Licensing.CORE 2017 Based: A retail price of $3,350 is charged against a pair of two cores and one needs to license a minimum of four cores. It requires enough knowledge to choose the Licensing option based on the requirements so that it becomes economical for one to deploy the Microsoft’s SQL Server services.CAL 2017 Based: $867 is charged per server and $202 per CAL is charged for every client accessing the server. In CORE based Licensing, you never worry about the number of users connecting to the server because you are having premium database capabilities.CORE 2017/2016 Licensing Method:ġ.Count the number of physical cores on your server.Ģ.Divide the number of cores by 2 to determine the number of licenses to be purchased since they are sold in packs of 2.CAL 2017/2016 Licensing Method:ġ.Each OS running the SQL Server must have a license.Pricing: It is designed for heavy usage internet deployments. This model is used when number of users or clients connecting to the server are not exactly known. It is bought in a pair for two cores and needs to be bought at least for four cores. – an internal workload as opposed to a web facing database).CORE Licensing:ĬORE Licensing requires us to buy license for all the core present on a physical server.

This is great in instances where the number of users will remain relatively consistent (i.e. CAL Licensing is best when the number of clients accessing the Database Server are known (and small in number). One license is bought for entire database server and then user or device CALs are bought separately. A CAL is needed for each client that accesses the server. These are:Client Access Licensing (CAL) ModelCore Licensing ModelCAL Licensing:ĬAL licensing is for clients that connect to the server. The selection between them is made on the based on the number of clients. It basically comes down to the number of clients. This guide will help you determine how to best license your environment. The CAL model is based off of the number of users accessing the database. The core model is based off the number of cores the physical server has. There are two types of licensing scenarios with SQL 2017 – the CORE model and the CAL model. I think you could do CALs for the second server. This is what I read the other day that helped us decide.
