Microsoft SQL Server 2019 Standard

What is included in Microsoft SQL Server 2019 Standard?

Database Engine – Full relational engine for transactional and reporting workloads.
Basic Availability Groups – Two-replica failover protection for a single database.
Failover Clustering – Two-node instance clustering for hardware redundancy.
TDE Encryption – Transparent Data Encryption protects data files at rest.
Core Capacity – Lesser of 4 sockets or 24 cores, 128 GB RAM.
Important – Client Access Licenses (CALs) are not included in this edition.

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

SQL Server 2019 Standard is the mid-tier relational database for departmental applications, line-of-business systems, and data marts that stay within 24 cores and 128 GB of engine memory. It runs the same query engine as Enterprise but caps scale and advanced availability features.

Cost Control – Standard pricing for workloads under engine limits.
Cross Platform – Installs on Windows, Linux, and Docker containers.
Built-in Security – TDE, Always Encrypted, and row-level security included.
Basic Failover – Two-replica availability groups guard one critical database.
No Size Cap – Relational databases scale to 524 PB.
Backup Compression – Shrinks backup files and shortens backup windows.

SQL Server 2017 to 2025: Editions and License Selection Compared
Buying advice covering differences, features, editions, support timelines, and how to choose the right license.

What does Microsoft SQL Server 2019 Standard do?

It stores, queries, and protects relational data using the same core Database Engine found in Enterprise, with hardware scale capped at the lesser of 4 sockets or 24 cores and 128 GB of buffer-pool memory. In practice this handles OLTP applications, ERP back-ends, and reporting databases for small and mid-sized deployments. SQL Server 2019 Standard also runs natively on Linux and in Docker containers, so you can host the same instance on a Windows VM or a Linux host without changing edition. It includes the in-database engine plus tools such as SQL Server Agent for scheduled jobs and maintenance.

Who is Microsoft SQL Server 2019 Standard best suited for?

It fits organizations whose busiest single instance stays under 24 cores and 128 GB of engine memory, which covers most departmental and line-of-business databases. A team running an accounting or inventory system that needs scheduled backups, basic redundancy, and encryption at rest gets all of that without paying for Enterprise. The 128 GB buffer-pool ceiling is the practical decision point: workloads that regularly read more than that into memory will see paging and slower queries that Enterprise would avoid. If you need only one protected database and can tolerate a two-replica failover model, Standard removes the cost of features you would not use.

How does SQL Server 2019 Standard compare to Enterprise edition?

Standard runs the same Database Engine as Enterprise but caps compute at the lesser of 4 sockets or 24 cores and buffer-pool memory at 128 GB, while Enterprise scales to the operating system maximum. The biggest functional gap is high availability: Standard supports only Basic Availability Groups (two replicas, one database, no readable secondary), whereas Enterprise allows multiple readable replicas and multi-database groups. Standard also omits online index rebuilds, table partitioning performance benefits, and Resource Governor, which matters for large always-on systems doing maintenance without downtime. For mid-tier workloads inside the scale limits, the engines behave identically, so the choice comes down to scale and availability needs.

SQL Server 2022, 2019, and 2017: Features and Differences
Side-by-side comparison of what each version added, removed, and changed across editions.

What technical limitations should users know before buying?

The hard ceilings are 24 cores, 128 GB of engine memory, and a single database per Basic Availability Group with no readable secondary replica. Standard also lacks online index rebuilds and table partitioning performance features, so large index maintenance requires taking objects offline during a window. In-memory OLTP is allowed but capped at 32 GB per database, far below the unlimited Enterprise allowance. Check your peak working-set size first: if queries routinely need more than 128 GB cached, Standard will page to disk and you will not get the throughput Enterprise delivers on the same hardware.

SQL Server Core Licensing and Minimum Requirements Explained
How core counts, four-core minimums, and edition limits affect what you actually need to buy.

Does SQL Server 2019 Standard require additional Client Access Licenses (CALs)?

It depends on the licensing model: under the Server + CAL model each user or device connecting to the server needs a SQL Server CAL, and those CALs are not included with this edition unless your package explicitly bundles them. Under the per-core model there is no user or device counting and no CAL requirement, but every physical core on the server must be licensed with a minimum of four cores per processor. A SQL Server CAL must be the same version or newer than the server, so a 2019 CAL can access a 2019 instance and older servers, but a 2017 CAL cannot legally access 2019. Choose per-core when you cannot count users or run internet-facing workloads, and Server + CAL when user counts are small and known.

SQL Server Buying Guide: License Models and CALs
How to read the per-core and Server + CAL models and pick the right SQL product.

Does SQL Server 2019 Standard support full Always On Availability Groups?

No. Standard supports only Basic Availability Groups, which protect one database with a single secondary replica and no read access on that secondary. Full Always On Availability Groups with multiple readable replicas and multi-database failover are exclusive to Enterprise edition. If you need to offload read traffic or fail over several databases together, Basic Availability Groups will not cover it, and the documented Read-Scale option does not work on Standard despite earlier documentation errors. For most departmental systems with one critical database, the two-replica Basic model is enough to meet a recovery-point objective.

Frequently asked questions about Microsoft SQL Server 2019 Standard

Can SQL Server 2019 Standard run on Linux?

Yes. SQL Server 2019 Standard runs on Windows, supported Linux distributions, and Docker containers using the same Database Engine. The same edition limits apply regardless of platform.

How long is SQL Server 2019 supported?

Mainstream support has ended, and extended support runs until January 8, 2030. During extended support you still receive security updates but not new feature changes.

Is in-memory OLTP available in Standard edition?

Yes, but it is limited to 32 GB of memory-optimized data per database. Enterprise has no fixed cap beyond available memory, so very large in-memory tables need Enterprise.

SQL Server FAQ: Standard, Enterprise, and CALs
Common buyer questions about edition differences and CAL requirements answered in one place.

Legal Information About Our Products

keys.express and keys.discount are online platforms for product keys. The product keys available in our shops for Windows and other software are inexpensive, secure, legal and come with an activation guarantee.

Below you will find the most important legal information about our products.

Unused and Non-Activated Product Keys

We offer exclusively unused and non-activated product keys. The keys have never been redeemed for activation and are fully available to the purchaser for the first-time activation of the respective product. A key that has already been redeemed could no longer be used for a new activation and is therefore not offered by us.

Trading in these product keys is permissible in the European Union and in Switzerland under current case law, provided that the necessary conditions are met. These conditions are as follows:

• The software must originally have been placed on the market with the consent of the rightholder within the territory of the EU, another contracting state of the EEA, or Switzerland by way of sale.
• The license for the software must have been granted in return for the payment of a fee intended to enable the rightholder to obtain remuneration corresponding to the economic value of the copy of the software.
• The rightholder must have granted the first acquirer the right to use the software permanently (for an unlimited period).
• Any improvements and updates that the subsequently downloaded computer program has compared to the originally downloaded one must be covered by a maintenance agreement concluded between the rightholder and the first acquirer.
• The original licensee must have made their own copies unusable.

This trade is legally permissible because the underlying license was already placed on the market with the consent of the rightholder within the EU/EEA or Switzerland in return for appropriate remuneration. As a result, the so-called principle of exhaustion has taken effect, which permits the resale of individual product keys — in particular those originating from volume license agreements. Microsoft or the respective software provider has already received appropriate remuneration for this.

keys.express and keys.discount ensure that the aforementioned conditions are met and that the lawful use of the software is guaranteed. The requirements arising from European legislation are also observed in Switzerland.

Important note: The acquisition of a product key through the transmission of a combination of numbers and letters in digital form does not, in itself, constitute a license for the lawful use of the program. The license only arises from the respective installation and the associated acceptance of the manufacturer's terms of use.

Further information can be found here:

• Legal assessment by Swiss lawyers

Overview of the Most Important Legal Information

• We offer unused, non-activated product keys for the activation of the respective computer programs. The key alone is not yet a license.
• The license only arises from the respective installation and the resulting acceptance of the terms of use. These terms of use govern the right to use the software between you and the respective manufacturer.
• The principle of exhaustion has, as a rule, taken effect — i.e. the license is "used up" — as soon as it was lawfully placed on the market for the first time. The products concerned are software placed on the market for unlimited-time use in the form of an activatable product key with the option to download the program. Microsoft or the respective software provider has received appropriate remuneration for this.
• You gain access to particularly attractively priced product keys from volume license agreements, which are to be treated legally in the same way as parts of volume licenses upon first acquisition.
• The software itself is always the same original software that is also obtained through official download channels or manufacturer sources. You are therefore not paying for a different or inferior version, but for a valid activation key or a corresponding license.
• All brand names and brand logos are registered trademarks, whose use here serves solely for product description — the ownership rights lie with the respective trademark holder.