Microsoft SQL Licensing - The Basics

Choosing a SQL licensing model: Per Core or Server + CAL?

Deciding on a licensing model can be a difficult task as both options have their own set of benefits. Core-based licensing is usually the only choice when SQL servers are being accessed externally (outside the company network). That’s because the Server + CAL model would require your organization to purchase a user/device CAL for every external user/device accessing the SQL server. This is essentially an almost impossible task to keep track of.

Moreover, core-based licensing is usually better for large companies as it is easier to manage. Imagine a large global organization with users and devices across the world. They might have a hard time tracking the number of CALs needed for their SQL servers. Plus, keep in mind that the number of employees and SQL servers usually don’t grow in a linear fashion. Therefore core-based licensing is generally cheaper for large organizations.

In comparison, the Server + CAL model might feel a bit complex, but it’s easy to manage for smaller organizations. Furthermore, Server + CAL licensing usally ends up being substantially cheaper for smaller organizations.

That’s a lot to keep in mind when taking a decision, but don’t worry, I’ve got just what you need! Just follow the decision tree below and see where you end up, simple as that!

Note that there are exceptions and that complex licensing scenarios may arise. For more detailed information about the licensing models, read more over at Microsoft’s SQL Server Licensing Guide (2017) or contact an official Microsoft partner.

But here’s the best part:

The power of vScope and the bundled content can make licensing tasks easier than ever before! For those with the core-based model, figuring out the number of cores that are running MS SQL software can be a hard task, especially for newcomers! But with an automatic inventorying tool, such as vScope, that’s not something you need to worry about.

With vScope you just need to open up the “MS SQL Core Documentation for Machines” report that’s included in every vScope installation. Not only will it show you all the machines with MS SQL software, but you can instantly see their CPU cores. You can find reports in vScope by either searching the Omnisearch or in your vScope Library.