A buyer side guide to SQL Server 2022 licensing in 2026. Per core versus Server plus CAL, edition choice, Software Assurance rights, Azure Arc billing, and where the cost really sits.
SQL Server 2022 is licensed either per core or by Server plus CAL, and the choice between those two models, plus the edition you pick and whether you carry Software Assurance, drives the real cost far more than the headline per core price.
This pillar is for buyers planning a SQL Server 2022 estate or renewal. Read it with the SQL Server licensing pillar, the Windows and SQL Server practical guide, and the Microsoft Knowledge Hub.
There are two models. Per core suits server workloads with many or unknown users. Server plus CAL suits smaller, countable user populations.
Microsoft documents both on its SQL Server 2022 pricing page. The model you choose is locked per license, so the decision matters at purchase time.
Per core licenses every physical core on the server, with a minimum of four cores per instance. Licenses are sold in two core packs.
Server plus CAL licenses the server once and then a Client Access License for each user or device. It wins when the user count is small and stable.
Edition choice is the biggest single cost lever. Enterprise costs several times Standard per core, so deploying Enterprise where Standard would serve is the classic over spend.
SQL Server 2022 editions and models, illustrative list per core per year
| Edition | Models | Indicative list per core | Best fit |
|---|---|---|---|
| Standard | Per core or Server plus CAL | 3,586 dollars | General workloads |
| Enterprise | Per core only | 13,748 dollars | Mission critical, large scale |
| Web | Per core, hosters | Low, SPLA only | Public web workloads |
| Express | Free | 0 dollars | Small, capped databases |
Software Assurance adds rights that change the economics. It enables License Mobility, free passive failover, and the Azure Hybrid Benefit.
SQL Server 2022 can be billed hourly per core through Azure Arc, turning a capital purchase into an operating cost. Microsoft describes the model in its SQL Server enabled by Azure Arc documentation.
The standard advice is to standardize on Enterprise Edition for simplicity and headroom. We disagree. In roughly 1 in 3 estates we reviewed, Enterprise was deployed where Standard would have met every requirement.
The buyer side move is to license each workload to its real need and reserve Enterprise for the features that genuinely require it, such as advanced availability groups and unlimited virtualization. Simplicity is not worth several times the per core price.
Source: Redress Compliance advisory engagement file, 2024 to 2025.
SQL Server cost is decided before you install anything. Pick the edition for the workload, not the org, and the per core price stops being the problem.
SQL Server 2022 is licensed either per core or by Server plus CAL. Per core suits workloads with many or unknown users, while Server plus CAL suits small, countable user populations. Enterprise Edition is per core only, and Standard supports both models.
Per core licensing requires a minimum of four cores per physical processor or virtual machine, and licenses are sold in two core packs. Even a two core virtual machine must be licensed for the four core minimum.
Enterprise Edition costs roughly three to four times Standard per core and adds advanced availability groups, unlimited virtualization with Software Assurance, and higher scalability. Standard meets the needs of most general workloads at a far lower per core price.
Yes. A passive failover replica is only free of license cost when the primary carries active Software Assurance. Without Software Assurance, the passive replica must be fully licensed, which often adds twenty to forty percent to the bill.
Software Assurance enables License Mobility across servers, free passive failover rights, version upgrade rights, and the Azure Hybrid Benefit. For estates that move workloads or use Azure, those rights frequently justify the Software Assurance cost.
Yes. SQL Server 2022 supports pay as you go billing per core through Azure Arc, which turns the license into an hourly operating cost. This suits variable or short lived workloads better than a perpetual per core purchase.
On a virtual machine you license the assigned virtual cores, subject to the four core minimum. Alternatively, licensing all physical cores on the host with Enterprise Edition and Software Assurance grants unlimited virtualization on that host.
Yes, SQL Server Express is free but capped on database size, memory, and CPU use. It suits small applications and development, but production workloads usually outgrow its limits and need Standard or Enterprise Edition.
Microsoft renewal moves, the EA framework, the M365 SKU framework, the Copilot framework, and the buyer side moves across the full Microsoft estate.
Used across more than five hundred enterprise engagements. Independent. Buyer side. Built for procurement leaders running the next renewal cycle.
SQL Server cost is decided before you install anything. Pick the edition for the workload, not the org, license replicas correctly, and the per core price stops being the problem.
500+ enterprise clients. 11 vendor practices. Industry recognized. One conversation can change what you pay for the next three years.
One short note on Microsoft licensing moves, EA and CSP mechanics, M365 and Azure SKU traps, and the buyer side levers we run in client engagements. No noise.
