SQL Server Pricing and Licensing Guide 2026: Editions, Models, and How to Choose
SQL Server pricing depends on two things: which edition you need and which licensing model you use. There is no single flat price. The current release is SQL Server 2025, released November 2025, with no changes to the core licensing model but significant updates to edition limits and features.
Most organizations do not need Enterprise Edition. Many accidentally overpay for it. Understanding the structure before purchasing is the single most effective way to control SQL Server costs.
Pricing note: All prices shown are SQL Server 2025 list prices at open NL (no-level) estimated retail price per the official Microsoft pricing PDF. Volume licensing, reseller discounts, and Software Assurance affect actual costs. Always verify current pricing with Microsoft or a reseller before budgeting.
1 SQL Server 2025 Editions Beginner
Entry-level edition for small applications and learning. Now supports up to 50GB per database (up from 10GB in SQL Server 2022). Capped at one CPU core and 1GB RAM. Express with Advanced Services is discontinued in 2025; all its features are now included in the base Express edition.
Free for development and testing only. Never production. SQL Server 2025 introduces two flavors: Standard Developer (mirrors Standard Edition limits) and Enterprise Developer (full Enterprise features). Choose Standard Developer when developing against a Standard production environment so test behavior accurately reflects production limits.
Full Enterprise features for a 180-day trial. Ideal for testing advanced functionality before purchasing. Transitions to a paid edition after the evaluation period expires.
Production-ready for most workloads. In SQL Server 2025: now supports up to 32 cores (up from 24) and 256GB RAM (up from 128GB). Also gains Resource Governor and Power BI Report Server, both previously Enterprise-only. Available with Per Core or Server + CAL licensing.
Mission-critical systems requiring Always On Availability Groups, advanced analytics, unlimited virtualization (with Software Assurance), and maximum scalability. Required for workloads exceeding Standard Edition limits. Per Core licensing only. Server + CAL is not available for Enterprise.
No longer available in SQL Server 2025. SQL Server 2022 Web Edition remains supported until January 2033. New deployments should migrate to Standard Edition for on-premises or Azure SQL for cloud. There is no direct like-for-like replacement at the same price point.
2 What Changed in SQL Server 2025 Beginner
SQL Server 2025 introduced no pricing or licensing model changes, but delivered significant edition updates that directly impact cost decisions:
| Change | SQL Server 2022 | SQL Server 2025 |
|---|---|---|
| Standard Edition — Max Cores | 24 cores | 32 cores |
| Standard Edition — Max RAM | 128 GB | 256 GB |
| Standard Edition — Resource Governor | Enterprise only | Included |
| Power BI Report Server | Enterprise + SA only | Standard and Enterprise |
| Express Edition — Max DB Size | 10 GB | 50 GB |
| Developer Edition | Single edition (Enterprise features) | Standard Developer + Enterprise Developer |
| Web Edition | Available | Discontinued |
| Pricing | Baseline | No change |
The biggest practical impact: Many organizations running Enterprise Edition solely because of the 24-core or 128GB RAM limits can now run the same workloads on Standard Edition in 2025. On a 32-core deployment, the potential saving is approximately $176,000. Audit your current Enterprise Edition usage before your next renewal. If you are not using Always On, unlimited virtualization, or advanced analytics features, Standard 2025 may be sufficient.
3 Licensing Models Intermediate
Per Core Licensing
- License every physical or virtual core SQL Server uses
- Minimum 4 cores per physical processor
- Sold in 2-core packs
- No CALs required, unlimited users and devices
- Only model available for Enterprise Edition
- Best for high or unpredictable user counts and internet-facing applications
Server + CAL Licensing
- One server license plus a Client Access License (CAL) for each user or device
- Standard Edition only, not available for Enterprise
- Server license: $989 | User or device CAL: $230
- Best for internal applications with small, fixed and known user counts
- Break-even vs Per Core: approximately 135 users on a 4-core server
Server + CAL multiplexing rule: You must count every user or device that accesses SQL Server data, even indirectly through middleware, applications, or reporting tools. A reporting tool that queries SQL Server on behalf of 500 users requires 500 CALs, even if only one service account connects to the database directly. Underestimating CAL count is one of the most common audit findings.
Subscription / Pay As You Go (Azure Arc)
- Monthly or hourly billing per core via Azure Arc
- Standard: $73 per core per month or $0.10 per core per hour
- Enterprise: $274 per core per month or $0.375 per core per hour
- No large upfront cost, operational expenditure model
- Per Core perpetual licensing becomes cheaper after approximately 3.5 years
- Best for hybrid and cloud scenarios with variable workloads
Software Assurance (SA)
- Annual subscription layered on top of perpetual licenses
- Approximately 25% of license cost per year
- Provides upgrade rights to new versions without repurchasing
- Required for virtual machine deployments in SQL Server 2022 and later
- Enables License Mobility to Azure (run SQL Server on Azure VMs using your existing licenses)
- Includes secondary replica HA rights for passive failover nodes
4 Real-World Pricing Numbers Intermediate
| Edition | Licensing Model | List Price | Minimum Cost |
|---|---|---|---|
| Express | N/A | Free | N/A |
| Developer (Standard) | N/A | Free | Dev/test only |
| Developer (Enterprise) | N/A | Free | Dev/test only |
| Standard | Per 2-core pack | $3,945 per pack | 4 cores min = $7,890 |
| Standard | Server + CAL | $989 + $230/CAL | Varies by users |
| Standard | PAYG (monthly) | $73/core/month | Requires Azure Arc |
| Enterprise | Per core | $7,562 per core | 8 cores min = $60,496 |
| Enterprise | PAYG (monthly) | $274/core/month | Requires Azure Arc |
| Web | N/A | Discontinued 2025 | N/A |
Hidden costs to budget for: Software Assurance (~25% of license cost annually), Windows Server licensing, hardware or cloud compute, backup storage, and DBA staff time. Non-compliance penalties during a Microsoft audit can reach 125% of list price for organizations exceeding a 5% compliance gap. Document every deployment.
5 Scenarios: Which Edition to Choose Beginner
Small Internal Application
4-core server, 25 internal users, moderate data growth, no strict SLA requirement.
Recommended: SQL Server Standard Edition with Server + CAL. Enterprise features are unnecessary and expensive at this scale. At 25 users, Server + CAL costs less than Per Core and scales predictably as long as user count stays below approximately 135.
Mission-Critical Production System
16-core server, Always On Availability Groups required, large datasets, heavy concurrency.
Recommended: SQL Server Enterprise Edition. Advanced HA, unlimited virtualization with Software Assurance, and In-Memory OLTP features justify the cost. Always On Availability Groups beyond basic are Enterprise-only.
Development and CI/CD Pipeline
Developers testing against production features, no production data, need accurate environment simulation.
Recommended: Developer Edition (Standard or Enterprise). Free, full-featured, matches production edition limits. In 2025, choose Standard Developer if production runs Standard Edition so test behavior accurately reflects the 32-core and 256GB RAM caps.
Proof of Concept or Pre-Purchase Evaluation
Evaluating Enterprise features, pre-purchase testing, 180-day window available.
Recommended: Evaluation Edition. Full Enterprise features, no cost, 180-day limit. The right choice for validating requirements before committing to a purchase.
32-Core Workload Currently on Enterprise
Currently on Enterprise due to core or memory limits, not using Always On or advanced analytics, upgrading from SQL Server 2022.
Recommended: Migrate to Standard Edition 2025. Standard now supports 32 cores and 256GB RAM. Potential saving on a 32-core deployment: approximately $176,000.
Variable or Short-Term Workload
Cloud or hybrid deployment, unpredictable scale, shorter-term planning horizon.
Recommended: PAYG via Azure Arc. Lower upfront cost with operational expenditure model. Perpetual Per Core licensing becomes cheaper after approximately 3.5 years. Evaluate based on your specific timeline.
Quick Reference
| Scenario | Recommended Edition |
|---|---|
| Learning or personal projects | Express |
| Development and CI/CD | Developer (Standard or Enterprise) |
| Proof of concept | Evaluation |
| Typical production workloads | Standard |
| Mission-critical systems | Enterprise |
| Web hosting (existing SQL Server 2022) | Web Edition until January 2033 |
| Web hosting (new deployment) | Azure SQL or Standard Edition |
6 Pros and Cons Beginner
Pros
- Clear edition structure with defined use cases for each tier
- Free Developer and Express editions reduce entry cost significantly
- Standard Edition covers most real-world production workloads
- Enterprise Edition offers unmatched depth for mission-critical systems
- Multiple licensing models provide flexibility for different deployment scenarios
- Standard Edition significantly upgraded in 2025 (32 cores, 256GB RAM, Resource Governor)
- PAYG model via Azure Arc reduces upfront cost for variable workloads
Cons
- Enterprise Edition pricing is significant at $60,496 minimum for an 8-core server
- Licensing can be complex without planning, especially in virtual environments
- Over-buying Enterprise Edition is extremely common and expensive
- Core-based licensing requires careful hardware sizing before purchase
- Software Assurance requirement for VM deployments adds hidden annual cost
- Web Edition discontinuation leaves hosting providers with no low-cost on-premises path
- Audit penalties for non-compliance are steep, up to 125% of list price
7 Workshop: Choosing the Right Edition Beginner
1 Define Your Requirements
Before looking at any pricing, answer these questions in writing. Requirements drive the edition, not the other way around.
- Is this production or non-production?
- How many users or applications will connect?
- How critical is uptime? Do you need Always On Availability Groups?
- How large will the data grow over 3 years?
- How many CPU cores does the server have?
- Will this run in a VM? (Software Assurance requirement applies)
2 Start with Developer or Evaluation Edition
Install Developer Edition for development environments or Evaluation Edition for testing advanced features before purchase. Generate test data to observe performance under realistic conditions:
-- Generate test data to observe performance under realistic load
INSERT INTO dbo.Orders (CustomerName, OrderTotal)
SELECT TOP 1000
'Test User',
ABS(CHECKSUM(NEWID())) % 1000
FROM sys.objects;
-- In 2025: choose Standard Developer if developing against Standard production limits
-- Standard Developer accurately reflects the 32-core and 256GB RAM caps3 Map Features to Editions
Create a feature checklist and map each requirement to the minimum edition that provides it:
| Requirement | Minimum Edition |
|---|---|
| Basic query engine and CRUD operations | Express |
| Full production workload up to 32 cores and 256GB RAM | Standard |
| Resource Governor | Standard (new in 2025) |
| Power BI Report Server | Standard (new in 2025) |
| Always On Availability Groups (full) | Enterprise |
| Unlimited virtualization | Enterprise + Software Assurance |
| Advanced analytics and OLAP | Enterprise |
If you cannot clearly justify Enterprise-specific features, Standard is the correct choice. Most production workloads do not require Enterprise Edition.
4 Estimate Licensing Cost
Work through this calculation before any purchase:
- Count available physical cores on the server
- Apply Per Core pricing with a minimum of 4 cores per processor
- Compare subscription vs perpetual over a 3-year window (PAYG wins short-term, perpetual after approximately 3.5 years)
- Add Software Assurance at approximately 25% annually if VMs are involved
- Factor growth: will you need more cores in 2 to 3 years?
8 Final Thoughts Beginner
SQL Server 2025 pricing is unchanged from 2022, but the edition changes are significant. Standard Edition is now a much stronger product, supporting 32 cores, 256GB RAM, Resource Governor, and Power BI Report Server. Many environments that were pushed into Enterprise Edition for capacity reasons can now run on Standard, potentially saving tens of thousands of dollars on the next renewal.
The smartest SQL Server environments are not the most expensive ones. They are the ones that align features, cost, and real business needs. Audit what you actually use before renewing, then buy exactly what you need.
Always consult a Microsoft licensing expert or authorized reseller before purchasing. Licensing is complex, subject to frequent updates, and the consequences of non-compliance during an audit are expensive. The numbers in this article reflect list pricing. Your actual cost through volume licensing agreements, Microsoft EA, or reseller channels will differ.
References
- Microsoft Docs: Editions and Supported Features of SQL Server 2025
- Microsoft Docs: What’s New in SQL Server 2025
- Microsoft: SQL Server 2025 Pricing PDF (Official)
- Microsoft: SQL Server 2025 Product Page
- Microsoft Docs: SQL Server 2025 Release Notes
- Microsoft Docs: Compute Capacity Limits by Edition of SQL Server
- Microsoft Docs: SQL Server Extended Security Updates (ESU)
- Microsoft: SQL Server Licensing Resources and Documents
- Microsoft Docs: SQL Server on Azure VMs Pricing Guidance
- SQLYARD: SQL Server Performance Tuning Complete Guide
- SQLYARD: SQL Server Instance Setup Best Practices
Discover more from SQLYARD
Subscribe to get the latest posts sent to your email.
