Microsoft SQL 2019 Enterprise 2-Core Key

What is included in Microsoft SQL Server 2019 Enterprise?

Full Database Engine – Every relational engine feature with no edition lockouts.
Always On Groups – Up to eight secondary replicas, five synchronous.
In-Memory OLTP – Unlimited memory-optimized data plus memory-optimized TempDB.
Advanced Performance – Online index rebuilds, partitioning, automatic plan tuning.
Data Virtualization – Query Oracle, MongoDB, and Hadoop through PolyBase.
Core Capacity – No compute or database size cap under core-based licensing.

What are the main benefits of Microsoft SQL Server 2019 Enterprise?

SQL Server 2019 Enterprise is the top-tier edition of Microsoft's relational database platform, built for Tier-1 production workloads. It removes the memory, core, and high-availability limits that constrain Standard edition, so the same hardware can carry far heavier transaction and analytics load.

No Memory Cap – Uses all RAM the operating system exposes.
True High Availability – Multi-replica failover with readable secondaries.
Online Maintenance – Rebuild indexes without taking tables offline.
Faster Analytics – Columnstore and batch mode handle reporting on live data.
Scales With Hardware – Performance grows as you add cores and memory.
Unlimited Virtualization – Any number of VMs when Software Assurance is active.

SQL Server 2017–2025 Buying Guide: License Models and CALs
How the core-based and Server+CAL models work, and how to choose the right SQL product for your environment.

What does Microsoft SQL Server 2019 Enterprise do?

It stores, secures, and processes relational and non-relational data for mission-critical applications, with every SQL Server feature unlocked. Unlike Standard edition, the engine is not capped at 128 GB of memory or 24 cores, so a single instance can use all CPU and RAM the operating system provides. This matters when an OLTP system grows past the point where Standard starts queuing memory grants and throttling parallelism. It also runs on Windows, Linux, and in containers, so the same license covers a move from a Windows host to a Linux deployment.

How does Enterprise compare to SQL Server 2019 Standard?

The core difference is scale and high availability: Enterprise has no memory or core ceiling, while Standard stops at 128 GB of buffer pool memory and the lesser of 4 sockets or 24 cores. Standard offers only basic availability groups (two replicas, one database, no readable secondary), whereas Enterprise supports up to eight secondaries with readable, backup-capable replicas. Online index rebuilds, table partitioning at scale, and memory-optimized TempDB are Enterprise-only, which is decisive for systems that cannot tolerate maintenance downtime. If your databases fit comfortably under 128 GB of active memory and you can rebuild indexes in a maintenance window, Standard usually covers the workload at a far lower cost.

SQL Server 2022, 2019, and 2017: Features and Differences
Side-by-side look at what changed across the three versions, so you confirm 2019 is the right release before buying.

What is the maximum database size in SQL Server 2019 Enterprise?

A single database can grow to 524 petabytes, so the practical ceiling is your storage hardware, not the license. Memory and CPU are likewise capped only by the operating system under core-based licensing, which is why Enterprise suits data warehouses and high-volume OLTP that outgrow Standard's 128 GB memory limit. This headroom is the main reason teams move to Enterprise: a busy reporting database that spills to disk on Standard often stays in memory on Enterprise. Keep in mind the limit applies per database, and you can host many databases on one instance.

Does SQL Server 2019 Enterprise still need PolyBase Enterprise for scale-out?

No. From SQL Server 2019 the PolyBase head node can run on either Enterprise or Standard, a change from 2016 and 2017 where the head node had to be Enterprise. This is a common buyer assumption worth checking: if data virtualization with PolyBase is your only reason to choose Enterprise, Standard may now cover it. Note that PolyBase scale-out groups were removed in SQL Server 2022, so a later upgrade would change how you deploy this feature. Choose Enterprise for the memory, availability, and online-maintenance advantages rather than for PolyBase alone.

SQL Server Core Licensing and Minimum Requirements
How core counts are licensed, the minimum cores you must license, and how to avoid buying the wrong quantity.

What should users check before choosing SQL Server 2019 Enterprise?

Confirm you actually need features locked to Enterprise, because the licensing cost gap over Standard is large. The deciding factors are usually memory above 128 GB, more than 24 cores, multiple readable replicas, or online index maintenance during business hours. Also check that unlimited virtualization, which Microsoft lists as an Enterprise benefit, depends on active Software Assurance and ends when that coverage lapses. If none of these apply, Standard handles most departmental and mid-size production databases at a fraction of the price.

Frequently asked questions about Microsoft SQL Server 2019 Enterprise

Does SQL Server 2019 Enterprise have a core or memory limit?

Under the core-based licensing model there is no compute capacity limit; the instance uses up to the operating system maximum for both cores and memory. The only 20-core cap applies to the legacy Server+CAL licensing model, which Microsoft no longer offers for new agreements.

Can SQL Server 2019 Enterprise run on Linux?

Yes. SQL Server 2019 runs on Windows, Linux, and in containers, and the same Enterprise license covers all of them. This lets you keep one license while moving a workload from a Windows host to a Linux server.

How many replicas do Always On availability groups support in Enterprise?

Enterprise supports up to eight secondary replicas, of which five can be synchronous, and those secondaries can be used for read-only queries and backups. Standard edition is limited to basic availability groups: two replicas, a single database, and no readable secondary.