Deploy SQL Server 2022 Standard with a perpetual 2-core license pack for business databases, line-of-business applications, reporting workloads, and hybrid data environments. Microsoft lists SQL Server 2022 Standard – per core as a 2-core pack, making this SKU the standard add-on unit for core-based SQL Server licensing. No CALs are required
SQL Server 2022 Standard 2 Core is a perpetual 2-core pack for organizations licensing SQL Server under Microsoft’s core-based model. This license gives your business lifetime use rights for the purchased version, without a subscription renewal requirement. Because this is SQL Server Standard Core, no CALs are required for users or devices accessing the licensed SQL Server instances. Microsoft’s license terms state that under the core license model, CALs are not needed for user or device access.
SQL Server 2022 Standard 2 Core uses Microsoft’s Core License Model, where licensing is based on processor cores rather than users or devices. Microsoft’s SQL Server 2022 pricing page lists Standard per core as a 2-core pack, and Microsoft’s license terms explain that Standard and Enterprise can be licensed under the core model or the Server + Client model, depending on the SKU purchased.
Compliance Notice
Single 2-core pack is usually not enough by itself for a compliant deployment. Microsoft requires licensing all physical cores on the server, subject to a minimum of 4 licenses per physical processor. If licensing an individual virtual OSE, Microsoft requires licenses equal to the number of virtual cores assigned, subject to a minimum of 4 licenses per virtual OSE. In practical terms, most buyers need at least two 2-core packs before deploying SQL Server Standard Core.
The table below summarizes Microsoft’s published install requirements, supported operating systems, and SQL Server 2022 Standard scale limits.
SQL Server 2022 adds Azure Synapse Link for SQL, enabling near real-time analytics over operational data with reduced impact on source databases. It also adds object storage integration for S3-compatible storage and supports querying parquet files with T-SQL through Data Lake Virtualization.
SQL Server 2022 introduces Ledger for tamper-evident database records, Microsoft Defender for Cloud integration, Microsoft Purview integration, Microsoft Entra authentication, expanded least-privilege permissions, and enhancements to Always Encrypted with secure enclaves.
SQL Server 2022 improves hybrid deployment options with the Link to Azure SQL Managed Instance, Azure-connected services, Azure extension integration, pay-as-you-go billing options, and backup/restore support to S3-compatible object storage.
For most buyers, the decision is whether SQL Server 2022 Standard provides enough hybrid, security, and query-processing value to replace SQL Server 2019 Standard. Both editions share the same Standard-edition compute and memory ceilings, but SQL Server 2022 adds newer Azure-connected services, Ledger, Query Store improvements, and stronger hybrid data capabilities.
| Feature Area | SQL Server 2022 Standard | SQL Server 2019 Standard |
|---|---|---|
| License Packaging | Standard per-core SKU sold as a 2-core pack. | SQL Server 2019 Standard supported Standard edition licensing; this comparison focuses on technical edition differences and workload value. |
| Max Compute Capacity | Lesser of 4 sockets or 24 cores per Database Engine instance. | Lesser of 4 sockets or 24 cores per Database Engine instance. |
| Max Memory Limits | Buffer pool 128 GB; columnstore cache 32 GB; memory-optimized data 32 GB per database. | Buffer pool 128 GB; columnstore cache 32 GB; memory-optimized data 32 GB per database. |
| Security & Governance | Adds Ledger, Microsoft Defender for Cloud integration, Microsoft Purview integration, Microsoft Entra authentication, and expanded least-privilege controls. | Includes core Standard security features such as Always Encrypted, Row-Level Security, Dynamic Data Masking, Server Audit, Database Audit, and TDE. |
| Hybrid / Analytics Direction | Adds Azure Synapse Link for SQL, Link to Azure SQL Managed Instance, S3-compatible object storage integration, and Azure-connected services. | Focuses on SQL Server 2019-era capabilities such as Big Data Clusters, data virtualization with PolyBase, Intelligent Query Processing, and Linux/container enhancements. |
No. This product is the SQL Server 2022 Standard Core SKU, not the Server + CAL SKU. Microsoft’s license terms state that under the core license model, you do not need CALs for users or devices to access your SQL Server instances.
Usually no. Microsoft requires all physical cores on the server to be licensed, with a minimum of 4 licenses per physical processor. Since this product covers 2 cores, buyers typically need at least two 2-core packs before they can meet the 4-core minimum, and larger servers may require more.
Yes, but VM licensing must follow Microsoft’s virtual OSE rules. For an individual virtual OSE, Microsoft requires licenses equal to the number of virtual cores assigned, subject to a minimum of 4 licenses per virtual OSE. Microsoft’s terms also state that for licenses acquired on or after November 16, 2022, virtual cores are only available with active Software Assurance, so VM deployment rights should be confirmed before rollout.
Microsoft’s SQL Server 2022 terms allow use of an earlier version, a lower edition, or an earlier version of a lower edition in place of a permitted instance. Microsoft also states that it is not obligated to supply prior versions or editions, so installation media and keys should be confirmed before purchase.
Choose SQL Server 2022 Standard Core Based for reliable database performance, modern security features, and flexible retail activation. With scalable architecture and long-term stability, your organization can manage critical data workloads efficiently. Order your SQL Server 2022 Standard Core Based retail license today and build a database environment designed for consistency and growth.
