SQL Server licensing is one of the most expensive and misunderstood components of the Microsoft stack. The per-core vs Server+CAL decision, virtualisation rules, and Azure Hybrid Benefit can dramatically affect your total cost.
SQL Server is among the most expensive software products in the Microsoft portfolio. SQL Server Enterprise per-core licensing at approximately $14,256 per 2-core pack means a single 2-socket server with 16 cores per socket requires over $228,000 in SQL Server Enterprise licences — before Software Assurance. For organisations with dozens or hundreds of SQL Server instances, this is a major cost driver in the Microsoft EA.
Understanding the two licensing models, choosing the right edition, and optimising virtualisation coverage are the three most impactful levers available to enterprise SQL Server buyers. Combined with Azure Hybrid Benefit for cloud-migrating workloads, significant cost reduction is achievable without reducing SQL Server capability.
SQL Server offers two licensing models with fundamentally different economic profiles depending on user count and server hardware.
The per-core model licenses every physical (or virtual) core in the SQL Server instance and permits unlimited users and devices to access the server. This is the only model available for SQL Server Enterprise edition and the typical choice for internet-facing or high-user-count environments.
The Server+CAL model charges a lower server licence fee (approximately $899 for SQL Server Standard) but requires a separate SQL Server CAL for each user or device accessing the server. This model is only available for SQL Server Standard, Web, and older Express editions.
| Model | Server Fee | Per-User/Device | User Limit | Best For |
|---|---|---|---|---|
| Per-Core | ~$3,586/2-core (Standard) ~$14,256/2-core (Enterprise) |
None required | Unlimited | High user counts, internet-facing |
| Server+CAL | ~$899 (Standard only) | ~$209/user or device CAL | Must count all users | Small user count (<25), internal only |
The crossover point between Server+CAL and per-core for SQL Server Standard on a 2-core server (minimum 4 cores): Per-core cost = 2 × $3,586 = $7,172. Server+CAL crossover = ($7,172 - $899) ÷ $209 = approximately 30 users. If more than ~30 users access the server, per-core is cheaper. For Enterprise edition, the crossover is much lower due to high per-core cost — Enterprise requires per-core only.
Choosing the right SQL Server edition is a significant cost decision. Enterprise edition costs approximately 4× more than Standard per core but includes features essential for mission-critical workloads.
Want independent help negotiating better terms? We rank the top advisory firms across 14 vendor categories — free matching, no commitment.
| Feature | Enterprise | Standard | Web | Developer |
|---|---|---|---|---|
| List price per 2-core | ~$14,256 | ~$3,586 | Low (SP only) | Free |
| Max memory | OS max | 128GB RAM | 64GB RAM | OS max |
| Max compute | Unlimited | 4 sockets / 24 cores | 4 sockets / 16 cores | Unlimited |
| Always On AG (readable secondaries) | Yes (unlimited) | Basic AG only | No | Yes |
| In-Memory OLTP | Yes | Limited | No | Yes |
| Columnstore indexes | Yes (all) | Limited | No | Yes |
| Data Compression | Yes | No | No | Yes |
| Advanced Analytics (R/Python) | Yes | No | No | Yes |
| Production use | Yes | Yes | SP/hosting only | No |
Developer edition is a frequently overlooked asset — it provides full Enterprise functionality for development and testing environments at no cost. Many organisations over-pay by deploying Standard or even Enterprise in non-production environments that could use Developer edition. A compliance review should confirm all non-production SQL Server instances are correctly licensed with Developer edition where appropriate.
SQL Server virtualisation licensing is a major source of compliance risk and over-spend. The rules differ significantly from Windows Server virtualisation licensing.
When SQL Server is deployed in a virtual machine, the per-core licence covers virtual cores (vCores). The minimum is 4 vCores per VM regardless of actual vCore assignment. This means even a single-vCore SQL Server VM requires 4 vCore licences (2 × 2-core packs).
SQL Server Enterprise with Software Assurance provides a powerful alternative to per-VM licensing: if you license all physical cores on a Hyper-V or VMware host with SQL Server Enterprise, you gain unlimited SQL Server Enterprise VM rights on that host — similar to Windows Server Datacenter's VM model. This is economically attractive for dense SQL Server virtualisation environments.
| Scenario | VMs on Host | Per-VM Approach Cost | Host-Level Approach Cost | Verdict |
|---|---|---|---|---|
| 32-core host (2-socket × 16) | 4 SQL VMs (8 vCores each) | 4 × 4 = 16 packs × $14,256 = $228K | 16 packs (host) × $14,256 = $228K | Break-even at 4 VMs |
| 32-core host | 8 SQL VMs (4 vCores each) | 8 × 2 = 16 packs × $14,256 = $228K | 16 packs (host) × $14,256 = $228K | Break-even at 8 VMs |
| 32-core host | 12 SQL VMs | 12 × 2 = 24 packs × $14,256 = $342K | 16 packs × $14,256 = $228K | Host licensing saves $114K |
Reviewing your SQL Server licensing position?
Our ranked advisors conduct SQL Server licence optimisation reviews and EA negotiations. Get matched.
For organisations with SQL Server workloads migrating to Azure, the Azure Hybrid Benefit is one of the most valuable Microsoft licensing rights available. SQL Server licences with active Software Assurance can be applied to Azure SQL services, dramatically reducing cloud costs.
Get the IT Negotiation Playbook — free
Used by 4,200+ IT directors and procurement leads. Oracle, Microsoft, SAP, Cloud — all covered.
| Azure Service | AHB Saving | Best For |
|---|---|---|
| SQL on Azure VMs | Up to 40% on compute | Lift-and-shift workloads needing full SQL Server control |
| Azure SQL Managed Instance | Up to 55% with AHB | Near-complete SQL Server compatibility, managed PaaS |
| Azure SQL Database | Up to 30% with AHB | Cloud-native apps, lower SQL Server compatibility requirement |
Azure SQL Managed Instance is increasingly attractive for organisations with complex on-premises SQL Server estates. It supports nearly all SQL Server Enterprise features in a fully managed PaaS service, reducing DBA overhead significantly while enabling AHB application. Combined with Reserved Capacity pricing (1 or 3-year commit) and AHB, SQL Managed Instance can be 55-65% cheaper than equivalent on-premises Enterprise licencing on new hardware.
SQL Server is typically included in Microsoft EA negotiations as a server product under the Server and Cloud Enrollment. Key negotiation considerations include:
Many organisations have significantly more SQL Server instances than their licence inventory reflects. Database servers installed for application backends, development tools with bundled SQL Express instances, and SharePoint databases running SQL Server Standard are common sources of unlicensed or under-licensed deployments. Use Microsoft's SAM engagement process proactively to identify and remediate before an audit request.
Deploy SQL Server Enterprise only where the specific Enterprise features are genuinely required: Always On with multiple readable secondaries, In-Memory OLTP for high-throughput OLTP, or columnstore for analytical workloads. Many databases running Enterprise could operate on Standard with no performance or availability impact.
Azure SQL Managed Instance with Azure Hybrid Benefit and Reserved Capacity is cost-competitive with on-premises Enterprise for most OLTP workloads. Migrating non-critical SQL Server instances to Azure SQL Database removes licence cost entirely and moves spend to a more flexible, lower-cost operational model.
Every non-production SQL Server instance (development, test, UAT, staging) should be running Developer edition. This is free, provides full Enterprise capability, and is explicitly permitted by Microsoft's Product Terms for non-production use. Remediating production licences applied to non-production environments is immediate savings with no risk.
If you have more than 8-10 SQL Server Enterprise VMs on a single physical host, licensing the host rather than individual VMs is almost always more cost-effective. For organisations planning to scale up SQL VM density on physical hardware, this is a critical planning consideration before the next EA renewal.
SQL Server is one of the highest-cost, highest-leverage items in a Microsoft EA. Expert advisory consistently delivers 20-40% savings through edition right-sizing, virtualisation optimisation, and Azure Hybrid Benefit application.