SQL Server 2022 Licensing Guide: Cores, CALs, and Cost Optimization

## SQL Server 2022 Licensing: A Practical Guide SQL Server licensing is notoriously complex. Choosing the wrong model can cost your organization thousands in unnecessary fees — or leave you non-compliant during a Microsoft audit. This guide breaks down the options clearly. ## Two Licensing Models SQL Server 2022 offers two licensing models. You must choose one per server. ### 1. Core-Based Licensing - **How it works**: License based on the number of physical CPU cores - **Minimum**: 4 core licenses per processor, 2 processor minimum = 8 cores minimum - **No CALs needed**: Any number of users/devices can connect - **Best for**: Web applications, external-facing databases, large user populations ### 2. Server + CAL Licensing - **How it works**: One server license + one CAL per connecting user or device - **CAL types**: Per-user (covers one user on any device) or per-device (covers one device for any user) - **Best for**: Small deployments with a known, limited number of users - **Not available for**: Enterprise edition (core-only) ## Standard vs Enterprise | Feature | Standard | Enterprise | |---|---|---| | Max Cores | 24 cores | Unlimited | | Max RAM | 128 GB | OS maximum | | Max Database Size | 524 PB | 524 PB | | Always On AG | Basic (1 DB) | Full (unlimited) | | In-Memory OLTP | 32 GB | Unlimited | | Compression | Row only | Row + Page + Columnstore | | Partitioning | No | Yes | | TDE | Yes (new in 2022) | Yes | | Licensing | Core or Server+CAL | Core only | | Price (retail) | ~€3,800/2-core | ~€15,000/2-core | For most SMBs, [SQL Server 2022 Standard](/en/products/microsoft-sql-server-2022-standard) provides more than enough capability. ## Cost Calculation Examples ### Example 1: Small Business — 20 Users, 1 Server **Server+CAL model (Standard)**: - 1 Server License: ~€900 - 20 User CALs: ~€200 each = €4,000 - **Total: ~€4,900** **Core model (Standard)** — assuming 8-core server: - 4 x 2-core packs: ~€3,800 each = €15,200 - **Total: ~€15,200** **Winner**: Server+CAL by a wide margin for 20 users. ### Example 2: Web Application — 1,000+ Users, 1 Server **Server+CAL model**: Impractical — 1,000+ CALs = enormous cost **Core model (Standard)** — 8-core server: - 4 x 2-core packs: ~€15,200 - **Total: ~€15,200** (regardless of user count) **Winner**: Core licensing — unlimited users for a fixed cost. ### Example 3: Wholesale Pricing Through Distivo Distivo offers [SQL Server 2022 Standard](/en/products/microsoft-sql-server-2022-standard) at wholesale pricing, significantly reducing the per-core cost. Contact us for volume quotes on enterprise deployments. ## Virtualization Licensing This is where SQL Server licensing gets tricky: ### Standard Edition - Each Standard license covers **2 virtual OSEs** (operating system environments) - You license per physical core, and each license grants 2 VMs - For more VMs, you need more core licenses ### Enterprise Edition - License **all physical cores** on the host, and you get **unlimited VMs** - This makes Enterprise cost-effective for highly virtualized environments ### Cloud (Azure/AWS) - Azure SQL: Pay-as-you-go or reserved instances (no traditional licensing) - AWS RDS: Included in instance pricing - Bring-Your-Own-License (BYOL): Use existing licenses with Software Assurance on dedicated hosts ## Software Assurance (SA) SA is an optional add-on (~25% of license cost per year) that provides: - Free upgrades to new SQL Server versions - 24/7 Microsoft support - Failover rights (passive secondary server) - Azure Hybrid Benefit (use licenses in Azure) - Training vouchers SA is worth it if you plan to stay on SQL Server long-term and want upgrade rights. ## New in SQL Server 2022 - **Azure Synapse Link** — Query Azure data from on-prem SQL Server - **Ledger tables** — Tamper-evident database records - **Query Store improvements** — Better performance tuning - **T-SQL enhancements** — GREATEST, LEAST, STRING_SPLIT improvements - **Managed disaster recovery** to Azure SQL - **Contained availability groups** — Simplified Always On setup - **Improved TempDB** — Better concurrent performance ## Common Licensing Mistakes 1. **Under-licensing cores in virtualized environments** — You must license all cores the VM *can* use, not just what it currently uses 2. **Forgetting passive failover rights** — Without SA, your passive failover server needs its own license 3. **Using Enterprise features on Standard** — If you accidentally enable an Enterprise feature, you owe Enterprise pricing 4. **Not counting all users for CALs** — Every user who queries the database needs a CAL, including indirect access through web apps 5. **Ignoring Azure hybrid benefits** — If you have SA, you can use your licenses in Azure at significant savings ## Our Recommendation For most organizations: - **Under 50 users with direct access**: Server+CAL with [SQL Server 2022 Standard](/en/products/microsoft-sql-server-2022-standard) - **Web applications or 50+ users**: Core-based Standard licensing - **Heavy virtualization**: Consider Enterprise for unlimited VM rights - **Cloud-first**: Azure SQL or AWS RDS may be simpler (no licensing to manage) Distivo offers SQL Server licenses at wholesale pricing with expert guidance on choosing the right model for your deployment.

SQL Server 2022 Licensing Guide: Cores, CALs, and Cost Optimization

Posts relacionados

How to Check If Your Windows License Is Genuine

Windows 11 System Requirements: Complete Checklist and Compatibility Guide

The Complete Guide to Choosing the Right Microsoft Office Edition

SQL Server 2022 Licensing Guide: Cores, CALs, and Cost Optimization

Posts relacionados

How to Check If Your Windows License Is Genuine

Windows 11 System Requirements: Complete Checklist and Compatibility Guide

The Complete Guide to Choosing the Right Microsoft Office Edition