Quick verdict
Choose Standard if your workload fits in 32 cores and 256 GB of buffer pool (SQL Server 2025), and high availability means a two-node failover cluster or basic availability groups with one database each. Choose Enterprise if you need more hardware, multi-database availability groups with readable secondaries, online index rebuilds and schema changes, or the Enterprise-only intelligent query processing features such as batch mode on rowstore and automatic tuning. SQL Server 2025 narrowed the gap: Standard's caps went up from 24 cores and 128 GB in SQL Server 2022, and Resource Governor is no longer Enterprise only.
SQL Server Standard and SQL Server Enterprise are the two paid editions of SQL Server 2025. They share the same Database Engine, T-SQL language and most programmability and security features, including the json and vector data types, Query Store, Always Encrypted, row-level security and Transparent Data Encryption. The differences are hardware limits, availability features, online operations and a set of performance features that Microsoft reserves for Enterprise.
Microsoft describes Enterprise as built for organisations that need the highest performance, security and scalability, and Standard as a balance of performance, security and affordability. Enterprise offers unlimited virtualisation for customers with Software Assurance, subject to the licensing guide. For development and testing, both editions have free Developer counterparts in SQL Server 2025: Standard Developer and Enterprise Developer. Web edition, which used to sit below Standard, is discontinued in SQL Server 2025.
Side by side
| Aspect | Standard | Enterprise |
|---|---|---|
| Compute per instance (2025) | Lesser of 4 sockets or 32 cores (24 cores in 2022 and earlier) | Operating system maximum (core licensing); 20 cores per instance under legacy Server + CAL |
| Buffer pool memory per instance (2025) | 256 GB (128 GB in 2022) | Operating system maximum |
| Columnstore cache / memory-optimized data | 32 GB each | Unlimited |
| Availability groups | Basic availability groups: two replicas, one database each | Always On availability groups with up to 8 secondary replicas (5 synchronous), plus contained and distributed availability groups |
| Failover cluster instances | Two nodes | Up to 16 nodes |
| Online operations | No online index create or rebuild, no online schema change | Online and resumable index create and rebuild, resumable online ADD CONSTRAINT, online schema change, online page and file restore |
| Intelligent query processing | Shared features such as parameter sensitive plan optimization and scalar UDF inlining | Adds automatic tuning, batch mode on rowstore, adaptive joins, memory grant, cardinality and DOP feedback |
| Resource Governor | Included from SQL Server 2025 (Enterprise only in 2022) | Included |
| List price per 2-core pack (2025) | USD 3,945 | USD 15,123 |
| Main trade-off | Hardware caps and limited availability features | Roughly 3.8 times the per core list price of Standard |
Key differences
Hardware limits, and what changed in SQL Server 2025
According to Microsoft's SQL Server 2025 scale limits table, a Standard instance uses at most the lesser of 4 sockets or 32 cores, 256 GB for the buffer pool, and 32 GB each for the columnstore segment cache and for memory-optimized data per database. Enterprise is limited only by the operating system, with unlimited columnstore and memory-optimized memory. One footnote matters for older agreements: Enterprise licensed under Server + CAL, which Microsoft says is not available for new agreements, is limited to 20 cores per instance.
For readers on older versions: the SQL Server 2022 page lists Standard at the lesser of 4 sockets or 24 cores and a 128 GB buffer pool. If an earlier sizing exercise pushed you to Enterprise only for memory or cores, recheck it against the 2025 limits.
High availability and online maintenance
Standard supports log shipping, failover cluster instances with two nodes, and basic availability groups, which Microsoft limits to two replicas and one database per group. Microsoft's basic availability groups page adds that the secondary has no read access, cannot take backups or run integrity checks, and that a basic group cannot be upgraded to an advanced one; it must be dropped and recreated on Enterprise. Enterprise supports full Always On availability groups with up to 8 secondary replicas, 5 of them synchronous, as well as contained availability groups, distributed availability groups, automatic read write connection rerouting and failover cluster instances with up to 16 nodes.
Online operations are the other large gap. Online index create and rebuild, resumable online index operations, resumable online ADD CONSTRAINT, online schema change, online page and file restore, fast recovery, mirrored backups and hot add memory are all Enterprise only in the 2025 feature tables. On Standard, index rebuilds run as offline operations, which block access to the affected table or index while they run, so maintenance windows need planning.
Query performance features
Several features in Microsoft's intelligent query processing family are Enterprise only in SQL Server 2025: automatic tuning, batch mode on rowstore, batch mode adaptive joins, batch mode and row mode memory grant feedback, memory grant feedback persistence and percentile, cardinality estimation feedback (including for expressions) and degree of parallelism feedback. Batch mode operations on Standard are limited to a degree of parallelism of 2. Enterprise also adds read-ahead, advanced scanning, NUMA aware large page memory, memory-optimized tempdb metadata, online nonclustered columnstore index rebuild, automatic use of indexed views by the optimizer (Standard needs the NOEXPAND hint), parallel index maintenance, parallel consistency checks, and star join and partitioned table parallel query optimizations.
Standard and Enterprise share parameter sensitive plan optimization, optional parameter plan optimization, optimized plan forcing, scalar UDF inlining, table variable deferred compilation, optimized locking, Query Store and Query Store hints. Whether the Enterprise-only features matter is workload specific; Microsoft does not publish a percentage gain, and nothing here is a benchmark.
Resource Governor, replication and other gaps
In SQL Server 2025 Resource Governor is available in Standard and Standard Developer "with the same functionality as in the Enterprise edition", according to Microsoft's What's new page; in SQL Server 2022 it was Enterprise only. Tempdb space resource governance is in both editions in 2025. Remaining Enterprise-only items include peer-to-peer transactional replication, Oracle publishing, distributed partitioned views, advanced R and Python integration, Query Store on secondary replicas, and Analysis Services without the Standard limits (16 GB for tabular and 64 GB for multidimensional models).
Pricing and licensing
Listed on Microsoft's SQL Server 2025 pricing sheet in October 2026, in US dollars, as open no-level estimated retail prices (your reseller price may differ):
- Enterprise: USD 15,123 per 2-core pack. Subscription through volume licensing: USD 5,434 per year per 2-core pack.
- Standard: USD 3,945 per 2-core pack under per core licensing, or USD 989 per server plus USD 230 per client access licence (CAL) under Server + CAL. Subscription through volume licensing: USD 1,418 per year per 2-core pack.
On these list prices, a 16-core server would need 8 two-core packs: USD 31,560 for Standard or USD 120,984 for Enterprise, before Software Assurance, discounts or tax. Microsoft also lists pay-as-you-go billing for both editions through Azure Arc. Check Microsoft's licensing guide for minimum core counts per server or virtual machine and for virtualisation rules before costing a deployment.
Pricing checked on the vendors' official pages on 7 October 2026. Prices change; confirm before buying.
Where each one leads
Standard strengths
- About a quarter of the Enterprise per core list price, with a Server + CAL option for small user counts
- SQL Server 2025 raised the caps to 32 cores and 256 GB of buffer pool
- Resource Governor included from SQL Server 2025
- Same engine, T-SQL, security features (including TDE) and most programmability features as Enterprise
- Basic availability groups and two-node failover clustering for simple high availability
Enterprise strengths
- No edition caps on cores or memory
- Full availability groups with up to 8 secondaries, readable secondaries, contained and distributed availability groups
- Online and resumable index operations and online schema change
- Enterprise-only intelligent query processing and data warehouse optimisations
- Unlimited virtualisation with Software Assurance
Limitations
Standard limitations
- Capped at the lesser of 4 sockets or 32 cores and 256 GB of buffer pool (24 cores and 128 GB in 2022)
- Basic availability groups only: two replicas, one database per group, no readable secondary, and no in-place upgrade to a full group
- Index rebuilds and schema changes are offline operations
- Batch mode limited to a degree of parallelism of 2, and several query processing features missing
Enterprise limitations
- Roughly 3.8 times the per core list price of Standard
- Licensed per core with no Server + CAL option for new agreements
- Many of its extra features only pay off on large or always-on workloads
When to choose each
Choose Standard if
- Your workload fits within 32 cores and 256 GB of buffer pool on SQL Server 2025
- A two-node failover cluster or basic availability groups meet your availability target
- You can schedule index maintenance in a window
- You want Resource Governor without Enterprise pricing
Choose Enterprise if
- You need more than 32 cores or 256 GB of buffer pool for one instance
- You need availability groups with several databases, readable secondaries or more than one secondary
- You need online index rebuilds or online schema changes for round-the-clock systems
- You rely on batch mode on rowstore, automatic tuning or other Enterprise-only query features
- You plan to run many virtual machines under Software Assurance
When neither is right
- You only need SQL Server for development and test: use the free Standard Developer or Enterprise Developer edition. See Express vs Developer.
- A small application fits in 50 GB per database and 4 cores: free Express may be enough. See Express vs Standard.
- You would rather pay for a managed service than licence servers: see Azure SQL Database vs SQL Server.
- Licence cost is the main obstacle: compare an open source engine in SQL Server vs PostgreSQL.
Final recommendation
Standard is the sensible default for most single-server business workloads, and SQL Server 2025 made it more capable with 32 cores, 256 GB of buffer pool and Resource Governor. Pay for Enterprise when you can name the feature you need: full availability groups with readable secondaries, online index and schema operations, more hardware than Standard allows, or Enterprise-only query processing features you have tested against your workload. Use Enterprise Developer to test those features for free before you buy, and confirm limits against the SQL Server version you will actually deploy.
Frequently asked questions
How many cores and how much memory can SQL Server Standard use?
In SQL Server 2025, Standard uses the lesser of 4 sockets or 32 cores per instance and up to 256 GB for the buffer pool. In SQL Server 2022 and earlier the limits were 24 cores and 128 GB. Enterprise is limited only by the operating system.
Do I need Enterprise for Always On availability groups?
For full availability groups, yes. Standard supports basic availability groups, which Microsoft limits to two replicas and one database per group. Enterprise supports up to 8 secondary replicas (5 synchronous), plus contained and distributed availability groups.
Is Resource Governor available in Standard edition?
Yes, from SQL Server 2025. Microsoft states it is available in Standard and Standard Developer with the same functionality as in Enterprise. In SQL Server 2022 it was Enterprise only.
How much more does Enterprise cost than Standard?
On Microsoft's SQL Server 2025 pricing sheet (October 2026), Enterprise lists at USD 15,123 and Standard at USD 3,945 per 2-core pack, about 3.8 times more per core. See the pricing section above.
Can I upgrade from Standard to Enterprise later?
Yes. Microsoft's supported upgrades page for SQL Server 2025 lists an edition upgrade from Standard to Enterprise (Server + CAL or Core licence).
Sources
- Microsoft Learn: Editions and supported features of SQL Server 2025
- Microsoft Learn: Editions and supported features of SQL Server 2022
- Microsoft Learn: What's new in SQL Server 2025 (edition changes)
- Microsoft: SQL Server 2025 pricing sheet (PDF)
- Microsoft Learn: Basic availability groups for a single database
- Microsoft Learn: Supported version and edition upgrades (SQL Server 2025)
Checked October 2026.
How we research comparisons: our editorial method.