Core based licensing, Server plus CAL, Software Assurance, virtualization rights, BYOL to Azure, and the buyer side moves that hold the renewal honest.
Microsoft SQL Server is licensed two ways, with two metric units, four editions, and a Software Assurance overlay that determines where the rights actually sit. The 2026 buyer view starts with the edition choice and ends with a clean Software Assurance posture.
Microsoft SQL Server is the relational database product that anchors most enterprise Microsoft estates. The licensing model is one of the more nuanced in the Microsoft portfolio because the edition choice, the metric model, and the Software Assurance overlay each move the math.
This guide covers SQL Server 2022 licensing for the 2026 renewal cycle, the core based and Server plus CAL metric models, Software Assurance posture, virtualization rights, Azure Hybrid Benefit, and the audit posture that holds the renewal clean.
Read the related Microsoft knowledge hub, the Microsoft advisory practice, and the Microsoft EA renewal playbook for the wider 2026 leverage framework.
Enterprise is the top tier with the full feature set: unlimited cores, advanced security, AlwaysOn availability groups, advanced analytics, and in memory OLTP.
Enterprise is the right answer for the mission critical workload that needs the full availability and analytics feature set. The list rate is roughly four times Standard.
Standard is the volume tier. It supports up to twenty four cores per instance, basic availability groups, and the common feature set used by most enterprise applications.
Standard is the correct answer for the majority of the estate. Procurement teams routinely buy Enterprise for workloads that have no need for the advanced feature set.
Web edition is the hosting service provider edition, licensed only through the Services Provider License Agreement. It is rarely seen outside of hosted environments.
Developer edition is the free edition with the full Enterprise feature set, restricted to development and test use. The audit trap is the Developer edition that drifts into production.
Core based licensing requires one core license per physical processor core on the host. The minimum is four cores per physical processor.
Core licenses are sold in two core packs. A typical sixteen core server requires eight two core packs at the edition rate.
A virtual machine on Standard or Enterprise edition can be licensed by the virtual core count. The minimum is four virtual cores per VM.
Virtual cores must align to physical cores including hyper threading. A virtual machine sized at three virtual cores still licenses at the four core minimum.
SQL Server 2022 edition comparison at a glance
| Edition | Metric | Min cores | Virtualization | Indicative list per 2 core pack |
|---|---|---|---|---|
| Enterprise | Core based | Four per VM or processor | Unlimited with SA on full host | Around 14,256 USD |
| Standard core | Core based | Four per VM or processor | Per VM license | Around 3,717 USD |
| Standard Server CAL | Server plus CAL | N or A | Per VM license | Around 931 USD plus CALs |
| Web | SPLA only | Hoster only | Hoster managed | Hoster rate |
| Developer | Free non production | None | Non production only | Zero |
Server plus CAL is available for Standard edition only. The model fits estates with a small named user pool against a Standard edition server.
The break even sits around twenty five named users per Standard edition server. Above that, core based pricing wins on the same workload.
Mixing Server plus CAL with core based across the same estate creates a documentation burden. The audit teams require evidence for each license model on each server.
Procurement should standardize on one model across the SQL Server estate. The exception is the legacy departmental application that genuinely sits at low user count.
Software Assurance is renewed annually at roughly twenty five percent of the underlying license cost. The renewal is the moment to test the retention case.
The case for retention is the version upgrade right, the virtualization rights for VM heavy estates, and the Azure Hybrid Benefit for any cloud migration. The case to drop is the static workload with no cloud trajectory.
Enterprise edition with active Software Assurance unlocks unlimited virtualization on a fully licensed host. Every physical core is licensed, and an unlimited number of SQL Server VMs can run on the host.
The right move for VM dense workloads is to license the host fully under Enterprise plus SA and consolidate the SQL footprint onto the licensed hosts.
Standard edition does not unlock unlimited virtualization. Each VM is licensed individually at the four virtual core minimum.
On a VM dense Standard edition workload, the per VM cost compounds quickly. The Enterprise plus SA host model often wins above four to six SQL VMs per host.
We inventoried our SQL Server estate ahead of the EA renewal. Forty two percent of our Enterprise edition cores carried workloads that ran cleanly on Standard. Redress structured the rationalization, the virtualization restructure, and the Azure Hybrid Benefit posture. The combined renewal landed nineteen percent under the prior year baseline.
Azure Hybrid Benefit allows SQL Server core licenses with active Software Assurance to be applied to Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure VMs.
The benefit reduces the pay as you go Azure SQL rate to the base compute rate, saving roughly fifty five percent on the equivalent license included rate.
Enterprise core licenses convert to four vCores of Azure SQL Database General Purpose tier, or one vCore of Business Critical tier per core.
Standard core licenses convert to one vCore of Azure SQL Database General Purpose tier per core. The Business Critical conversion requires the Enterprise license stack.
VM sprawl is the most common audit finding. A SQL Server VM that runs on a host without the right edition and SA stack triggers a full host license requirement on the audit.
Document every SQL Server VM with its host, edition, and SA status before any Microsoft engagement that could open an audit conversation.
Passive failover servers carry strict configuration requirements to qualify for the no cost license. The auditors check the configuration before granting the benefit.
Any active workload on the failover, including read replicas, breaks the no cost benefit. The license then applies to the failover at full rate.
Developer edition is free for non production use only. Audit finds the Developer instance carrying production traffic on a regular cadence.
Run a monthly scan that flags Developer edition instances on production networks. The remediation is to upgrade to a licensed edition before the audit lands.
The mid term operating discipline is where the structural cost discipline lives. Quarterly SQL inventory reconciliation, the VM sprawl audit, and the Azure Hybrid Benefit utilization review keep the estate clean.
Read the related Microsoft EA renewal playbook for the cross product framework.
SQL Server 2022 is licensed by the core for Enterprise and Standard editions, or by Server plus CAL for Standard edition only. The core based model requires a minimum of four cores per physical processor or per virtual machine.
A SQL Server 2022 Enterprise two core pack lists at around 14,256 United States dollars. Standard two core pack lists at around 3,717 dollars. Software Assurance adds roughly twenty five percent of the license rate per year.
Software Assurance grants version upgrades, license mobility, virtualization rights, the Azure Hybrid Benefit, and passive failover rights. The retention case is strong for VM dense estates and for any cloud trajectory. Static workloads with no upgrade plan can drop SA.
Azure Hybrid Benefit applies on premises SQL Server licenses with active Software Assurance to Azure SQL Database, Managed Instance, or VMs. The benefit reduces the pay as you go rate by roughly fifty five percent.
Enterprise plus Software Assurance grants unlimited VM density on a fully licensed host. Standard edition requires per VM licensing at the four virtual core minimum. Mixed model estates carry a documentation burden at audit.
No. Developer edition is licensed for development and test use only. A Developer instance carrying production workload triggers a full edition license requirement on audit.
An active SQL Server license with Software Assurance grants one passive failover instance at no incremental cost, provided the failover meets the documented configuration criteria. Any active workload on the failover, including read replicas, breaks the benefit.
Pull the SQL Server license report from System Center, reconcile against the production host inventory, and compare against the Microsoft EA renewal playbook benchmarks. The Redress Microsoft practice runs the joint audit on every engagement.
Microsoft renewal posture, EA framework, SQL Server licensing, M365 SKU framework, Copilot framework, SPLA hosting, 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.
Our SQL Server licensing was a black box. Forty percent of our Enterprise cores carried workloads that ran fine on Standard. The advisory restructured the edition mix, locked the virtualization rights, and applied Azure Hybrid Benefit to the cloud footprint. The EA renewal landed nineteen percent under our prior baseline.
500+ enterprise clients. 11 vendor practices. Industry recognized. One conversation can change what you pay for the next three years.
SQL Server edition moves, Software Assurance posture, Azure Hybrid Benefit framework, and the wider Microsoft leverage signals across the practice.
Once a month. Audit patterns, renewal benchmarks, vendor commercial signals across Oracle, Microsoft, SAP, Salesforce, IBM, Broadcom, AWS, Google Cloud, ServiceNow, Workday, Cisco, and the GenAI vendors. No follow up sales pressure.
Free providers (Gmail, Yahoo, Outlook) cannot subscribe. Work email only. Unsubscribe in one click.