SQL Server 2022 introduced a 10% price increase, tightened virtualisation rules requiring Software Assurance for VM-level licensing, and added cloud-linked options including Azure Arc pay-as-you-go billing. The core licensing decisions are deceptively complex: Per-Core vs Server+CAL, Enterprise vs Standard Edition, physical vs virtual licensing, and cloud licensing including Azure Hybrid Benefit and licence mobility. This guide covers pricing for every model, edition comparison, virtualisation and cloud rules, failover and DR rights, worked cost scenarios, common audit findings, and optimisation strategies that reduce SQL Server licensing costs by 20 to 40%.
| Licensing Model | List Price (USD) | Best For | Key Risk |
|---|---|---|---|
| Enterprise: Per-Core | ~$15,123 per 2-core pack | Mission-critical workloads; unlimited virtualisation with SA | 4x cost of Standard; over-deployed where Standard would suffice |
| Standard: Per-Core | ~$3,945 per 2-core pack | Medium-to-large user bases; virtualised environments | Still significant at scale; 24-core cap per instance |
| Standard: Server+CAL | ~$989/server + ~$230/CAL | Small internal apps with limited users (under 100) | CAL count grows with users; not viable for external-facing |
| Subscription (EA/CSP) | ~$5,434/yr per 2-core (Ent); ~$1,418/yr (Std) | Annual payment model; includes SA benefits | Higher total over 3+ years vs perpetual |
| Pay-As-You-Go (Azure Arc) | ~$274/core/month (Ent); ~$73/core/month (Std) | Short-term projects; seasonal/elastic workloads | 3-5x more expensive than perpetual over 3+ years for steady workloads |
| Developer / Express | Free | Non-production development; very small databases under 10 GB | Using Developer in production = full audit exposure at Enterprise pricing |
Microsoft requires a minimum of 4 core licences per physical processor, regardless of actual core count. A 2-socket server with 2-core processors still requires 8 core licences. Modern servers with 16 to 32 cores per socket drive licensing costs to $121K to $242K per server for Enterprise Edition. Choosing a 2-socket/16-core server over a 2-socket/32-core server saves $121,000 in SQL Server Enterprise licensing alone. Always evaluate SQL Server licensing cost alongside hardware procurement decisions.
| Capability | Enterprise Edition | Standard Edition |
|---|---|---|
| List price (2-core pack) | $15,123 (~4x Standard) | $3,945 |
| Maximum compute | OS maximum (unlimited cores) | Lesser of 4 sockets or 24 cores |
| Maximum memory | OS maximum (unlimited) | 128 GB per instance |
| Virtualisation rights (with SA) | Unlimited VMs on fully licensed host | Maximum 2 VMs (licensing virtual cores of each) |
| Always On Availability Groups | Full (unlimited replicas, read-scale secondaries) | Basic only (2-node, no read secondaries) |
| TDE / Table Partitioning | Included | Not available |
| In-Memory OLTP | Included (unlimited) | Limited (32 GB cap) |
| Failover rights (with SA) | 1 passive secondary (no licence required) | 1 passive secondary (no licence required) |
We consistently find that 30 to 50% of SQL Server Enterprise deployments do not use any Enterprise-exclusive feature. These databases could run on Standard at 75% lower cost. On a 2-socket, 16-core server, the difference is $121,000 (Enterprise) vs $31,560 (Standard), a savings of $89,440 per server. For an enterprise with 10 such servers, that represents $894,400 in recoverable licensing cost. Conduct a feature-usage audit on every Enterprise instance. Query sys.dm_db_persisted_sku_features: if no Enterprise features are returned, it is a candidate for Standard.
| Scenario | Server+CAL Cost | Per-Core Cost | Cheaper Model |
|---|---|---|---|
| 25 users, 8-core server (Standard) | $989 + (25 x $230) = $6,739 | 4 x $3,945 = $15,780 | Server+CAL (57% cheaper) |
| 50 users, 8-core server | $989 + (50 x $230) = $12,489 | $15,780 | Server+CAL (21% cheaper) |
| 75 users, 8-core server | $989 + (75 x $230) = $18,239 | $15,780 | Per-Core (13% cheaper) |
| 100 users, 16-core server | $989 + (100 x $230) = $23,989 | 8 x $3,945 = $31,560 | Server+CAL (24% cheaper) |
| 200 users, 16-core server | $989 + (200 x $230) = $46,989 | $31,560 | Per-Core (33% cheaper) |
| Internet-facing (unlimited users) | Not viable: cannot CAL unknown users | $15,780 to $31,560+ depending on cores | Per-Core (only option) |
For Standard Edition on an 8-core server, the breakeven is approximately 65 users. Below 65 users, Server+CAL is cheaper. Above 65, Per-Core wins. For 16-core servers, the breakeven rises to approximately 133 users. For internet-facing applications where you cannot identify or count every accessing user, Per-Core is the only compliant option. Server+CAL is never viable for web-facing databases.
SQL Server 2022 significantly tightened virtualisation licensing. The most critical change: Software Assurance (SA) is now effectively required for any VM-level licensing. Without SA, you must licence all physical cores on the host server regardless of how many cores are allocated to the SQL Server VM.
| Environment | Licensing Rule | SA Required? | Cost Impact |
|---|---|---|---|
| Physical server | Licence all physical cores (min 4 per processor) | Not required for basic licensing | Straightforward; cost scales with core count |
| VM with SA (vCore licensing) | Licence only the virtual cores assigned to the SQL Server VM (min 4 vCores) | Yes | Efficient; licence only what the VM uses |
| VM without SA | Must licence ALL physical cores on the host server | N/A (no SA = full host licensing) | 2 to 10x more expensive; 32-core host = $63K+ Standard or $242K+ Enterprise |
| Enterprise + SA (unlimited virtualisation) | Licence all physical cores on host; run unlimited SQL Server VMs | Yes | Cost-effective for high VM density (5+ SQL VMs per host) |
| Azure (Azure Hybrid Benefit) | BYOL existing SQL Server licences with SA to Azure VMs or Azure SQL | Yes | Up to 55% savings on Azure SQL compute vs pay-as-you-go |
| AWS / GCP (Licence Mobility) | Deploy SQL Server licences on authorised cloud provider shared infrastructure | Yes | Enables BYOL to non-Microsoft clouds; form submission required |
| Azure Arc pay-as-you-go | On-premises SQL billed per-core/per-month through Azure subscription | Not required | ~$274/core/month (Ent); breakeven vs perpetual at 3-4 years |
| Failover Scenario | Additional Licence Required? | Condition |
|---|---|---|
| Passive secondary (cold standby) | No: free with SA | Server must be truly passive (no queries, reporting, or maintenance). 1 free per licensed primary. |
| Active secondary (read workload) | Yes: full licensing required | Any read or write workload on the secondary requires its own licences. |
| Always On Basic (Standard) | No: 1 passive replica free with SA | 2-node Basic AG with 1 passive replica; no readable secondaries. |
| Log shipping / database mirroring | No: passive secondary free with SA | Secondary must remain passive. Any read/reporting use = fully licensable. |
| Failover cluster instance (FCI) | No: passive node free with SA | Passive FCI node runs no SQL workload. Only 1 passive per active. |
A secondary SQL Server used for read workloads, reporting, or maintenance is not passive and requires full licensing. This is one of the most common audit findings. If your Always On Availability Group has readable secondaries (Enterprise only), each readable secondary requires its own per-core licensing. The cost of "free" reporting on a secondary can be $60K to $240K+ when Microsoft counts the cores. If read workloads on the secondary are not business-critical, disable them and save the licensing cost.
| Audit Finding | How It Occurs | Typical Cost Impact | Prevention Strategy |
|---|---|---|---|
| Enterprise deployed where Standard suffices | Enterprise installed by default; no Enterprise-exclusive features used | $50K to $120K over-licensing per server | Audit feature usage (sys.dm_db_persisted_sku_features); downgrade where possible |
| VM licensing without SA | SQL Server on VMs without Software Assurance; Microsoft requires licensing all physical host cores | $100K to $500K+ per host | Ensure SA coverage for all virtualised SQL Server; or isolate SQL VMs on dedicated hosts |
| Under-licensed core count | Physical cores added during hardware upgrade or VM cores increased without licence addition | $15K to $60K per 2-core pack gap | Change management process requiring licence review for any hardware/VM change |
| Missing CALs (Server+CAL model) | New users accessing SQL Server without corresponding CAL; indirect access through middleware | $230 per missing CAL x user count | Audit all direct and indirect SQL Server access paths |
| Active failover server not licensed | Secondary SQL Server used for read workloads, reporting, or maintenance | $30K to $240K (full licensing of secondary) | Enforce strict passivity on failover servers |
| Developer Edition in production | Developer Edition (free) used for production workloads | $60K to $240K+ (back-licensing at Enterprise rates) | Audit all SQL Server instances for edition; replace Developer with licensed edition |
Identify Enterprise Edition instances not using Enterprise-exclusive features; migrate to Standard Edition. Typical savings: $50K to $120K per server (75% per-server reduction). Query sys.dm_db_persisted_sku_features on each instance. If no Enterprise features are returned, it is a candidate for Standard.
Right-size server and VM core allocations to match actual SQL Server workload CPU requirements. Typical savings: 20 to 40% per server. Analyse CPU utilisation over 30+ days; reduce VM vCPU allocation; select smaller physical hardware for new deployments. Hardware selection is a licensing decision.
Switch from Per-Core to Server+CAL for Standard Edition instances with fewer than approximately 65 users (8-core server breakeven). Typical savings: $5K to $15K per eligible server. Inventory user counts for each Standard instance; convert when CAL count is below breakeven.
Consolidate multiple SQL Server VMs onto fewer physical hosts fully licensed with Enterprise + SA. This triggers unlimited virtualisation rights: licence the host once, run unlimited SQL Server VMs. Cost-effective when running 5+ SQL VMs per host. Reduces total licensed core count while maintaining capacity.
Apply existing SQL Server licences with SA to Azure VMs or Azure SQL Database for up to 55% savings on compute costs. This is the single most impactful cost lever for organisations migrating SQL Server workloads to Azure. Ensure you are claiming AHB on every eligible Azure resource. See Microsoft Knowledge Hub.
Per-Core licensing charges based on the number of physical or virtual cores running SQL Server, with a minimum of 4 cores per processor. It covers unlimited users and is required for Enterprise Edition. Server+CAL charges a per-server fee plus a Client Access Licence for every user or device that accesses SQL Server. Server+CAL is available only for Standard Edition and is cost-effective for small, internal applications with fewer than approximately 65 users per 8-core server. Per-Core is the only option for internet-facing or external-user scenarios.
Choose Enterprise only when you need Enterprise-exclusive features: unlimited virtualisation rights with SA, full Always On Availability Groups with readable secondaries, Transparent Data Encryption, table partitioning, or unlimited In-Memory OLTP. Enterprise costs 4x Standard. If your workload does not use any Enterprise-exclusive feature, Standard Edition at 75% lower cost is the correct choice. Query sys.dm_db_persisted_sku_features to verify whether Enterprise features are actually in use.
Effectively yes for SQL Server 2022. Without SA, you must licence all physical cores on the host server regardless of how many cores are allocated to the SQL Server VM. With SA, you can licence only the virtual cores assigned to the VM (minimum 4 vCores). On a 32-core host, this is the difference between licensing 4 vCores ($7,890 Standard) and licensing 32 physical cores ($63,120 Standard). SA is also required for Azure Hybrid Benefit, Licence Mobility to AWS/GCP, and free passive failover rights.
Azure Hybrid Benefit allows you to use existing SQL Server licences with active Software Assurance on Azure VMs or Azure SQL Database, reducing compute costs by up to 55% compared to pay-as-you-go pricing. You bring your own SQL Server licence (BYOL) and pay only for the Azure infrastructure. This applies to both Enterprise and Standard Edition licences. Ensure you are claiming AHB on every eligible Azure SQL resource. It is the single most impactful cost optimisation for SQL Server workloads moving to Azure.
No. SQL Server Developer Edition is free but explicitly restricted to non-production use only (development, testing, demonstrations). Using Developer Edition for any production workload is a licence violation. If discovered in an audit, Microsoft will back-licence at Enterprise per-core rates, which can cost $60K to $240K+ depending on the server. Audit all SQL Server instances for edition and replace any Developer Edition instances running production workloads.
Only if it is truly passive. With Software Assurance, you get 1 free passive secondary per licensed primary. The secondary must run no queries, reporting, maintenance, or any other workload. If the secondary is used for read workloads (such as Always On readable secondaries), it requires its own full per-core licensing. This is one of the most common SQL Server audit findings. If you need a readable secondary, budget for full licensing on that server.
Azure Arc pay-as-you-go allows you to run SQL Server on-premises with per-core monthly billing through an Azure subscription instead of purchasing perpetual licences upfront. Enterprise costs approximately $274 per core per month; Standard approximately $73. No upfront licence purchase or Software Assurance required. The breakeven vs perpetual licensing is typically 3 to 4 years. This model is cost-effective for short-term projects, seasonal workloads, or uncertain demand, but 3 to 5x more expensive than perpetual for steady long-term workloads.
Redress Compliance provides independent Microsoft advisory for SQL Server licensing optimisation: edition right-sizing, core count optimisation, virtualisation licensing assessment, Azure Hybrid Benefit maximisation, Server+CAL conversion analysis, audit defence, and EA negotiation. We typically save enterprises 20 to 40% on SQL Server licensing costs. Complete vendor independence. No Microsoft partnerships, no resale commissions.
Microsoft Advisory ServicesIndependent Microsoft advisory helping enterprises optimise SQL Server licensing through edition right-sizing, core count optimisation, virtualisation assessment, and Azure Hybrid Benefit maximisation. Fixed-fee engagement models.