18 Nov 2026

SQL Server Licensing: Per Core vs. Server + CAL—Which Is More Efficient?

Choosing a Microsoft SQL Server licensing model is often a challenge for many companies. Beyond technical requirements, organizations must ensure that their costs align with their number of users and business growth plans. In general, SQL Server offers two primary licensing models: Per Core and Server + CAL (Client Access License). Each has its own advantages and is suited to different use cases.

 

Understanding the Per Core Model


In the Per Core model, licensing is based on the number of processor cores used by the SQL Server instance. This model does not limit the number of users or devices that can access the database.
The primary advantage of the Per Core model is flexibility. Companies do not need to purchase additional CALs whenever the number of users increases. This is highly beneficial for public-facing applications, websites, ERP systems, or any application accessed by a large or unpredictable number of users.
This model is also the only option for SQL Server Enterprise Edition and is typically used in virtualized environments that require high scalability.
However, the initial cost of Per Core licensing is generally higher than that of the Server + CAL model, especially for servers with a large number of cores.

 

Understanding the Server + CAL Model


The Server + CAL model consists of two licensing components:

  • A SQL Server license for the server running the database.
  • 2. A CAL for each user or device that accesses the SQL Server.

This approach is often considered more economical for companies with a relatively small and predictable number of users—for instance, internal applications used only by specific departments, such as Finance or HR.


For example, if a company has one SQL Server accessed by 20 employees, it simply needs to purchase one server license and 20 CALs.


The main drawback of this model is that costs can rise as the number of users grows. Furthermore, license administration becomes more complex, as the company must ensure that every user or device accessing the server has the appropriate CAL.


When Should You Choose Per Core?

The Per Core model is generally more suitable when:

  • The number of users is difficult to calculate or changes frequently.
  • The database is used by web applications or public-facing services.
  • The organization has thousands of internal or external users.
  • The environment utilizes virtualization and requires high workload mobility.
  • SQL Server Enterprise Edition is being used.

Under these conditions, the Per Core model typically provides predictable licensing costs, eliminating the need to continuously monitor the number of users.

 

When Should You Choose Server + CAL?


The Server + CAL model is usually a more efficient choice when:

  • The number of users is relatively small and stable.
  • The system is used exclusively by the organization's internal users.
  • The organization maintains good control over the number of users and devices.
  • Licensing budget is a primary consideration.

For small to medium-sized enterprises with a limited number of users (in the tens), this model often results in lower costs compared to Per Core licensing.

 

So, Which Is More Efficient?


The answer depends on your business requirements and system usage patterns. If an organization has a large number of users, evolving applications, or a modern virtualized environment, the Per Core model is generally a simpler and more flexible choice in the long run.


Conversely, if the number of users is limited and can be clearly defined, the Server + CAL model can offer significant cost savings.


Before selecting a licensing model, organizations should analyze their user count, infrastructure architecture, business growth plans, and virtualization needs. Through proper evaluation, an organization can achieve the optimal balance between licensing compliance, performance, and cost efficiency.

 

For more information, contact MII: customer.experience@mii.co.id