SQL Server Standard vs Enterprise: Licensing Comparison

Last verified: August 19, 2026 — limits checked against Microsoft’s official SQL Server 2022 documentation and pricing. The figures below apply to SQL Server 2022; they’ve been unchanged since at least SQL Server 2019.

SQL Server Standard and Enterprise run the same core database engine. The differences that matter are hard resource ceilings and a handful of advanced features Standard doesn’t include.

The short answer

Standard

Memory limit (Database Engine)

128 GB

  • Core limitLesser of 4 sockets or 24 cores
  • Licensing modelPer-core or Server + CAL
  • Unlimited virtualization✗
Most single-server and departmental workloads
No resource ceiling

Enterprise

Memory limit (Database Engine)

OS maximum

  • Core limitNone
  • Licensing modelPer-core only
  • Unlimited virtualization✓
Large-scale, high-performance, heavily virtualized workloads

Why the memory and core limits matter

Standard caps the Database Engine at 128 GB of memory and the lesser of 4 sockets or 24 cores, whether the instance runs physical or virtualized. For most single-server deployments this is well above what gets used. It only becomes a real constraint on large, memory-hungry workloads — big OLTP systems, heavily indexed reporting databases, or consolidated instances serving many applications at once.

Enterprise removes both ceilings entirely: memory is limited only by the operating system, and there’s no core cap.

Licensing model difference

Standard can be licensed either per-core or under the Server + CAL model (a server license plus a Client Access License for each user or device). Enterprise is per-core only — there’s no Server + CAL option. Enterprise core licenses also carry unlimited virtualization rights: once every physical core on the host is licensed, you can run any number of Enterprise VMs on it, similar in spirit to how Windows Server Datacenter handles virtualization.

Feature differences beyond capacity

Enterprise adds capabilities Standard doesn’t have: more Always On Availability Groups secondaries, online (non-blocking) index operations, advanced analytics and machine learning integration, and additional high-availability options. Most of these matter for large or mission-critical deployments — a small or mid-sized workload typically won’t need them.

Note: edition choice isn’t reversible by just buying a bigger license later — moving from Standard to Enterprise is a full edition upgrade, not a core add-on. Size for headroom if you’re already close to Standard’s limits.

Which edition is right for you?

  • Choose Standard if your workload fits comfortably under 128 GB of memory and 24 cores, and you don’t need Enterprise-only high-availability or analytics features.
  • Choose Enterprise if you’re running large-scale, memory- or core-intensive workloads, need unlimited virtualization on a host, or require Enterprise-only availability features.

See SQL Server licenses for current options.

Sources: Microsoft — SQL Server 2022 Pricing, Microsoft Learn — Compute Capacity Limits by Edition of SQL Server.