SQL Server Standard vs Enterprise: Features, Limits and Licensing
SQL Server Standard and Enterprise run the same database engine. The differences are in what each edition is allowed to use: how many cores and how much memory one instance can address, which high-availability features are switched on, a list of performance and online-maintenance features that only Enterprise carries, and the licensing rules around virtual machines. Enterprise costs close to four times as much per core at list price (SQL Server cost by edition is in the price table of the 2025 vs 2022 comparison), so the edition choice is usually the largest single number in a SQL Server estate.
This is the edition-against-edition comparison, on SQL Server 2022 and 2025. If the question is which version to run, the SQL Server 2022 vs 2025 comparison covers that. The general SQL Server licensing rules for the current version are in the SQL Server 2025 licensing guide. The figures below come from Microsoft's own edition feature pages, the SQL Server 2025 Product Terms and Microsoft's SQL Server 2025 pricing sheet.
Compute and memory limits
Enterprise is limited only by the operating system. Standard caps what a single instance can use, and SQL Server 2025 raised that cap. On 2022, a Standard instance uses the lesser of four sockets or 24 cores and up to 128 GB of buffer pool memory. On 2025, Microsoft lists the lesser of four sockets or 32 cores and 256 GB of buffer pool.
| Per instance | Standard 2022 | Standard 2025 | Enterprise (2022 and 2025) |
|---|---|---|---|
| Compute | Lesser of 4 sockets or 24 cores | Lesser of 4 sockets or 32 cores | Operating system maximum |
| Buffer pool memory | 128 GB | 256 GB | Operating system maximum |
| Columnstore segment cache | 32 GB | 32 GB | Unlimited |
| Memory-optimized data per database | 32 GB | 32 GB | Unlimited |
| Maximum database size | 524 PB | 524 PB | 524 PB |
| Batch mode degree of parallelism | Limited to 2 | Limited to 2 | No edition limit |
Two details matter when reading those caps. First, a cap limits what one instance can use, not what has to be licensed: every core in the operating system environment still counts towards the licence. Second, the 2025 change is real headroom. A workload that moved to Enterprise on 2022 only because it needed 28 cores or 200 GB of buffer pool fits inside Standard on 2025.
High availability and disaster recovery
Both editions can protect a database. The difference is scale and how much stays online during maintenance.
| Feature | Standard | Enterprise |
|---|---|---|
| Failover cluster instance | 2 nodes | Up to 16 nodes |
| Availability groups | Basic availability groups: two replicas, one database | Full availability groups: up to 8 secondary replicas, 5 of them synchronous |
| Contained and distributed availability groups | No | Yes |
| Log shipping, backup compression, encrypted backup | Yes | Yes |
| Online index create and rebuild, online schema change | No | Yes |
| Online page and file restore, mirrored backups | No | Yes |
A basic availability group protects one database with one secondary. An application with eight databases that must fail over together needs eight basic groups on Standard, or one availability group on Enterprise. The online operations are the other deciding line: on Standard, rebuilding a large index takes it offline for the duration, which is fine for a system with a nightly window and not for one that has none.
Features only in Enterprise
Microsoft's feature tables for 2022 and 2025 list these as Enterprise only, with Standard showing No:
- Online index operations, resumable online index create and rebuild, and online schema change.
- Parallel query processing on partitioned tables and indexes, star join query optimizations and global batch aggregation.
- Batch mode on rowstore, batch mode adaptive joins, memory grant and cardinality estimation feedback, and automatic tuning.
- Peer-to-peer transactional replication and Oracle publishing.
- Advanced R and Python integration (Standard's basic integration is limited to 2 cores and in-memory data sets).
- Hot add memory, NUMA-aware large page memory allocation, read-ahead and advanced scanning.
Just as important is the list of features that people assume are Enterprise only and are not. Transparent data encryption, Always Encrypted, backup encryption, table and index partitioning, data compression, row-level security and auditing are all marked Yes for Standard on both 2022 and 2025. Resource Governor moved the other way: Enterprise only on 2022, available in Standard on 2025. An Enterprise purchase justified by TDE or partitioning alone is worth a second look.
Per core or Server + CAL
Enterprise is licensed per core. Microsoft's edition pages note that Enterprise under Server + CAL is not available for new agreements, and that existing Enterprise Server + CAL licences are limited to 20 cores per instance. Standard can be licensed either way: per core, or as a server licence plus a client access licence for every user or device accessing it.
Per-core licensing counts every physical core in the server, with a minimum of four core licences per physical processor, or every virtual core in a virtual machine, with a minimum of four per VM. Microsoft's list prices for SQL Server 2025, as of September 2026, are open no-level estimated retail prices; resellers and agreements set the real figure:
| SQL Server 2025 | Unit | List price (USD) | Subscription (USD) |
|---|---|---|---|
| Enterprise | 2-core pack | $15,123 | $5,434 a year |
| Standard, per core | 2-core pack | $3,945 | $1,418 a year |
| Standard, server | Server | $989 | Not listed |
| Standard, CAL | User or device | $230 | Not listed |
Source: Microsoft, SQL Server 2025 pricing sheet (November 2025 edition). On those numbers, a 16-core physical server costs $31,560 in Standard core licences and $120,984 in Enterprise. Under Server + CAL, the $989 server licence plus $230 a head reaches the same $31,560 at roughly 133 users or devices, so Server + CAL tends to suit small, known user populations and per core suits anything facing the internet or a user count nobody can pin down. The SQL Server 2022 licensing guide walks through the same per-core and Server + CAL choice in more detail.
Virtualization: per VM or per host
This is where the editions diverge most in cost. Under the SQL Server 2025 Product Terms, licensing an individual virtual machine is available only for subscription licences or licences with active Software Assurance, and each VM needs licences for its virtual cores with the four-licence minimum. That applies to both editions.
Enterprise adds one right Standard does not have. When every physical core of a server is licensed with Enterprise core licences and active Software Assurance or a subscription, the customer may run any number of SQL Server instances in any number of operating system environments on that server. Microsoft's edition pages call this unlimited virtualization. On a dense host, that one right can make Enterprise cheaper than licensing each Standard VM separately; on a host with two small SQL VMs, it rarely does.
Moving VMs between hosts brings in licence mobility and reassignment rules, which are a separate subject covered in SQL Server on VMware: licensing the host, the VM or the cluster. The short version: know whether Software Assurance is active before a cluster starts moving licensed VMs around.
Reporting: Power BI Report Server
On SQL Server 2022 and earlier, Power BI Report Server rights come only with Enterprise core licences under active Software Assurance, and they expire with the Software Assurance. On SQL Server 2025, Microsoft makes Power BI Report Server available to Standard and Enterprise customers, and reporting services are consolidated under it. An estate that bought Enterprise with Software Assurance mainly for reporting should check whether that reason still holds once it moves to 2025.
When Standard is enough
Standard covers the workload when all of these are true:
- Each instance fits inside 32 cores and 256 GB of buffer pool on 2025, or 24 cores and 128 GB on 2022.
- High availability can be met by a two-node failover cluster instance or one basic availability group per database.
- Index rebuilds and schema changes can run in a maintenance window, offline.
- The server hosts a handful of SQL VMs, not a dense virtualization farm.
- Nobody depends on an Enterprise-only feature from the list above, which a feature-usage check can confirm before renewal.
Enterprise earns its price when one of those fails: an instance that needs more compute or memory than the cap, several databases that must fail over together, zero-downtime maintenance, or enough virtual machines on one host that unlimited virtualization beats per-VM counting.
The hard part is rarely the rule; it is knowing what is actually deployed. Which instances run which edition, on how many cores, on which hosts, and whether Software Assurance covers them. LICENSEWARE's Microsoft Deployment Manager reads that from the deployment data an estate already collects and prices it against the edition rules, so the Standard-or-Enterprise call is made per instance, not per assumption.
FAQ
What is the main difference between SQL Server Standard and Enterprise?
Standard caps each instance at the lesser of four sockets or 32 cores and 256 GB of buffer pool on SQL Server 2025 (24 cores and 128 GB on 2022), and limits high availability to two-node clusters and basic availability groups. Enterprise has no edition caps, adds online maintenance and advanced performance features, and is the only edition with unlimited virtualization under Software Assurance.
Does SQL Server Standard support Always On availability groups?
Standard supports basic availability groups: two replicas protecting a single database. Full availability groups, with up to eight secondary replicas and several databases failing over together, are Enterprise only.
Is transparent data encryption available in SQL Server Standard?
Yes. Microsoft's feature tables list TDE, Always Encrypted, backup encryption, partitioning and data compression as supported in Standard on both SQL Server 2022 and 2025. None of them on its own is a reason to buy Enterprise.
How much does SQL Server Enterprise cost compared with Standard?
Microsoft's SQL Server 2025 list price is $15,123 per 2-core pack for Enterprise and $3,945 for Standard, open no-level estimated retail as of September 2026. Standard is also sold at $989 per server plus $230 per CAL; your reseller or agreement sets the price you actually pay.
