SQL Server 2022 licensing, the complete guide
SQL Server 2022 is licensed per core or by Server plus CAL, and the model choice, the edition, and Software Assurance drive the real cost far more than the headline rate. This guide walks the rules, the math, and the three places estates routinely overpay.
Prepared by Redress Compliance · August 6, 2026 · Microsoft licensing advisory. Based on 30 to 40 data platform reviews run 2024 to 2026.
Executive summary
SQL Server 2022 sells under two models. Per core licensing prices the hardware: a four core minimum per physical processor or virtual machine, sold in two core packs, with Enterprise at roughly $7,128 per core and Standard at $1,859 per core at list. Server plus CAL, available on Standard only.
Prices the population: $989 per server plus $230 per user or device Client Access License.
The breakeven sits near 30 users on a four core server, and near 64 on eight cores.
Edition is the bigger lever than model. Enterprise is per core only and roughly 3.8 times the Standard rate, and it earns that premium only when you use what it adds: more than 128GB of memory per instance, advanced availability groups, or unlimited virtualization with Software Assurance.
Across our reviews, Enterprise sat where Standard would serve in 1 estate out of 3.
Software Assurance, at roughly 25 percent of the license price per year, is not an optional extra in most real estates: it is what makes passive failover replicas free, unlocks License Mobility into cloud and outsourced infrastructure.
And carries the Azure Hybrid Benefit. Passive replicas licensed without Software Assurance added 20 to 40 percent to the SQL bill in the estates where we found them.
SQL Server 2025 changes none of this: Microsoft confirmed no pricing or licensing model changes at release, with broad channel availability from January 2026.
The decisions in this guide, model, edition, core count, and Software Assurance posture, carry straight into the next version and into the renewal conversation.
The two licensing models, and when each wins
Per core licensing covers unlimited users against the hardware, so it suits internet facing workloads, large populations, and anywhere counting users is impractical.
Server plus CAL inverts the math: a cheap server license plus a Client Access License for every user or device that touches the instance, directly or through middleware. It wins only when the population is small, countable, and stable.
| Model | List price | Editions | Where it wins |
|---|---|---|---|
| Per core | $7,128 per core Enterprise, $1,859 per core Standard, two core packs, four core minimum | Enterprise and Standard | Unknown or large user counts, external facing systems, virtualization at scale |
| Server plus CAL | $989 per server plus $230 per user or device CAL | Standard only | Small named populations: the breakeven is about 30 users on four cores, 64 on eight |
| Pay as you go | Hourly per core through Azure Arc, introduced with the 2022 release | Both | Spiky or short lived workloads where a perpetual license would sit idle |
The multiplexing rule decides more CAL disputes than any other sentence in the product terms. A user reaching SQL Server through an application server, a web front end, or an integration layer still needs a CAL.
If you cannot name every human and device behind the middleware, you are a per core estate whether you like it or not.
Edition choice, the 3.8x question
Enterprise Edition costs roughly 3.8 times Standard per core, and the delta is earned by a specific feature list, not by seniority of the workload. Standard Edition carries a 128GB memory ceiling per instance, basic availability groups with a single replica, and the full database engine.
Enterprise adds unlimited memory, advanced availability groups with up to eight secondary replicas, online index operations, transparent data encryption at scale, and, with Software Assurance, unlimited virtualization on fully licensed hosts.
The buyer side test is mechanical: list the Enterprise only features actually in use per instance. In our reviews the answer was none for one estate in three, usually because an instance was provisioned Enterprise years ago for a project that never shipped the availability design.
Downgrading a 16 core instance from Enterprise to Standard returns roughly $84K per instance at list, and nothing about the workload changes.
Virtualization is where edition and Software Assurance interact. License every virtual machine individually at four cores minimum, or license every physical core of the host with Enterprise plus Software Assurance and run unlimited VMs on it.
The host approach wins past roughly four VMs per host, and it is the construct that makes dense private cloud SQL estates affordable.
The Windows Server and SQL Server practical guide works the host math with worked examples, and the Hyper V licensing guide covers the hypervisor side of the same decision.
The SQL Server core licensing playbook
The full decision tree: per core versus CAL breakevens by core count, the virtualization constructs, Software Assurance math, and the audit exposure checklist for the three errors in this guide.
Get the white paper →Software Assurance, the 25 percent that pays for itself
Software Assurance adds roughly 25 percent of the license price per year, and in most estates it is cheaper than what it replaces. Three rights do the heavy lifting:
- Free passive failover replicas. Without Software Assurance, every passive high availability or disaster recovery replica needs a full license. With it, one passive replica per licensed instance is free, on premises and one more in Azure. The estates that licensed replicas without it paid 20 to 40 percent more than they needed to.
- License Mobility. The right to move licenses into shared cloud infrastructure and outsourcers. Without it, a lift into managed hosting can require repurchasing the estate.
- Azure Hybrid Benefit. Existing SQL licenses with Software Assurance offset Azure SQL pricing, commonly 30 to 40 percent off the pay as you go rate for the same workload.
What we saw across data platform reviews, 2024 to 2026
Across roughly 30 to 40 Microsoft data platform reviews run between 2024 and 2026, model choice and edition mismatch drove most of the overspend, and the pattern repeated regardless of company size:
Virtual estates licensed for allocated cores rather than the four core minimums the VMs actually required after rightsizing.
Instances carrying the 3.8x Enterprise premium with no Enterprise feature in use, usually inherited from a project that never shipped.
The third pattern was the passive replica error in both directions: replicas licensed in full despite Software Assurance making them free, and, worse, replicas not licensed at all in estates that had dropped Software Assurance, which is the finding a Microsoft audit monetizes first.
A data platform review that reconciles deployed cores, editions, and replica posture against entitlements is the highest yield hour in Microsoft licensing.
SQL Server 2025, and what carries forward
SQL Server 2025 reached general availability in late 2025 with no pricing or licensing model changes, and purchasing opened across the volume channels in January 2026.
The per core and Server plus CAL constructs, the four core minimum, and the Software Assurance rules all carry forward unchanged, so nothing in this guide expires with the version number.
What does change is the renewal conversation.
A version transition is the natural moment Microsoft proposes moving the estate to subscription constructs or Azure, and the natural moment for you to fix the edition mix and core counts first, because every error in the current estate reprices into whatever you sign next.
The SQL Server licensing 2026 analysis covers the current price list in detail, and the SQL Server licensing pillar indexes the full topic.
- Percentile standing for your exact deal size and industry, from real closed transactions
- Scenario simulation before the call: test alternative terms and see the financial impact of each
- A negotiation playbook, talking points, and a two page executive brief on day one
Your first five moves
- Inventory deployed cores against licensed cores, per instance and per host, including every passive replica. The gap in either direction is money.
- Test every Enterprise instance against the Enterprise feature list. No feature in use means a Standard downgrade at the next true up or renewal, worth roughly $84K per 16 core instance at list.
- Price the passive replica estate under both Software Assurance postures before renewing or dropping it. The 25 percent is usually cheaper than licensing the replicas.
- Re run the CAL breakeven on every Server plus CAL instance: populations grow, and an instance that crossed 30 users is quietly cheaper per core.
- Fix the estate before the version conversation. Every misallocated core reprices into the next agreement. The Microsoft practice runs this review with you, on your side of the table.
Frequently asked questions
How much does SQL Server 2022 cost per core?
Enterprise Edition lists at roughly $7,128 per core and Standard at $1,859 per core, both sold in two core packs, with a four core minimum per physical processor or virtual machine.
A minimal four core Standard instance therefore starts around $7,435 at list, and a 16 core Enterprise instance around $114K before discounts.
When is Server plus CAL cheaper than per core?
On Standard Edition with small, countable populations. At $989 per server plus $230 per CAL, the breakeven against four cores of Standard sits near 30 users, and near 64 users on eight cores.
Users reaching the database through middleware still need CALs, so the model only works when every human and device behind the application layer can be named.
Do passive failover replicas need a license?
Only if you lack Software Assurance. With Software Assurance on the primary, one passive on premises replica and one Azure replica are free.
Without it, every passive replica needs a full license, which added 20 to 40 percent in the estates where we found it, and it is the first finding a Microsoft audit monetizes.
Is SQL Server Standard Edition enough for production?
For most workloads, yes. Standard carries the full database engine with a 128GB memory ceiling per instance and basic availability groups.
Enterprise earns its 3.8x premium only for large memory instances, advanced availability groups, online index operations at scale, or unlimited virtualization on licensed hosts. One estate in three in our reviews paid the premium without using any of those.
Did SQL Server 2025 change licensing or pricing?
No. Microsoft confirmed no pricing or licensing model changes with the 2025 release, and channel availability opened in January 2026. Per core, Server plus CAL, the four core minimum, and the Software Assurance rules all carry forward, so estate decisions made on 2022 rules remain correct.
How does SQL Server licensing work in virtual machines?
License each VM individually with a four core minimum per VM, or license all physical cores of the host with Enterprise plus Software Assurance for unlimited VMs on that host. The host construct usually wins past four VMs per host.
Licensing allocated vCPUs rather than required minimums is how estates end up 15 to 30 percent over licensed.
