SQL Server licensing has a reputation for being confusing, and it’s earned. There are several editions, two licensing models, minimums per processor and per virtual machine, and price differences that run into tens of thousands of dollars. The good news is that for most small and mid-sized businesses the decision comes down to two or three questions.
This guide covers SQL Server 2022, the current version, using Microsoft’s own pricing and edition documentation.
The SQL Server 2022 editions
| Edition | Microsoft price (open, no level) | Licensing | Who it’s for |
|---|---|---|---|
| Enterprise | $15,123 per 2-core pack | Per core | Large, mission-critical databases |
| Standard (per core) | $3,945 per 2-core pack | Per core | Business apps with many or unknown users |
| Standard (server) | $989 per server | Server + CAL | Small teams with a known number of users |
| Standard CAL | $230 per user or device | Used with the server license | |
| Developer | Free | Per user | Development and testing only |
| Express | Free | None | Small apps and databases up to 10 GB |
| Web | Through hosting partners | Hosting only | Public websites run by hosting providers |
Prices are Microsoft’s published estimated retail prices for SQL Server 2022 in US dollars. Your actual price depends on the channel and agreement.
Per core vs Server + CAL
SQL Server Standard can be licensed in two ways, and choosing the right one can save a lot.
Per core
You license every core the SQL Server instance can use, and you don’t count users at all. Microsoft sells core licenses in 2-core packs, with a minimum of four core licenses per physical processor, or per virtual machine if you license VMs individually. A small server with one 8-core processor needs 8 core licenses, which is four 2-core packs.
Per core is the only option for Enterprise edition, and it’s the right choice for Standard when users are hard to count: public-facing websites, customer portals, or hundreds of internal users.
Server + CAL
You buy one server license per SQL Server, then a Client Access License for every user or device that uses it, directly or through an application. It’s only available for Standard edition.
For a small office with 10 to 20 known users, Server + CAL is often far cheaper than per core. Run the numbers at Microsoft’s prices: one server ($989) plus 15 CALs ($230 each) comes to about $4,439, while a 4-core minimum on per-core licensing is two packs, or $7,890.
The common mistake is undercounting. Users who reach SQL Server through a web app, a reporting tool or another server still need CALs. That rule is called multiplexing, and it doesn’t let you off the hook.
Standard vs Enterprise: what the extra money buys
Microsoft’s edition documentation sets these limits for SQL Server 2022:
| Standard | Enterprise | |
|---|---|---|
| Compute per instance | Lesser of 4 sockets or 24 cores | Operating system maximum |
| Buffer pool memory per instance | 128 GB | Operating system maximum |
| Columnstore segment cache | 32 GB | Unlimited |
| Licensing | Per core or Server + CAL | Per core only |
Beyond scale, Enterprise unlocks the high-end features: full Always On availability groups with multiple readable secondaries (Standard only has basic two-replica groups for one database each), online index rebuilds, advanced partitioning and performance features, and unlimited virtualization when you license every core on the host with Software Assurance.
For a typical line-of-business application, such as accounting, ERP, CRM or an internal web app with a database under a few hundred gigabytes, Standard is plenty. Enterprise earns its price on large data warehouses, high-transaction systems and setups that can’t tolerate downtime.
The free editions
- Developer has every Enterprise feature, free, but only for development and testing. It can’t run production workloads.
- Express is free for production but limited to 10 GB per database, 1,410 MB of buffer pool memory and the lesser of one socket or four cores. It’s fine for small apps, point-of-sale systems and prototypes.
A common path is Express for a new app, then Standard once the database passes 10 GB or performance starts to matter.
Virtual machines and containers
When SQL Server runs in a VM, you can license the VM’s virtual cores (minimum four per VM) instead of the whole host. That’s usually the cheapest route for one or two SQL VMs on a larger host. To run many SQL VMs on one host, licensing every physical core with Enterprise plus Software Assurance gives you unlimited virtualization. Remember that the Windows Server underneath needs its own license too. See our Windows Server 2025 licensing guide.
Pay-as-you-go through Azure Arc
SQL Server 2022 also introduced a pay-as-you-go option: connect your on-premises server to Azure Arc and pay monthly for the cores you use. It suits seasonal or temporary workloads. For a database that runs year after year, a one-time license is usually cheaper.
Buying SQL Server 2022
We carry SQL Server 2022 Standard and SQL Server 2022 Enterprise keys, delivered by email with the official download link. Kymakers is operated by Makers Unity LLC, a Microsoft partner. If you’re not sure which edition or licensing model fits your server, ask us before you buy and tell us your core count and number of users. We’d rather you buy the right license once.
SQL Server 2022 has mainstream support until 11 January 2028 and extended (security) support until 11 January 2033, according to Microsoft’s lifecycle page.
Related guides
Building or upgrading the server underneath? Start with Windows Server 2019 vs 2022 vs 2025 and Windows Server CALs explained. Developers working against SQL Server will also want the right IDE, so see Visual Studio 2026 editions compared. All our database and server licenses are on the SQL Server page.
SQL Server licensing: FAQ
How is SQL Server 2022 licensed?
Per core (Enterprise and Standard) or Server + CAL (Standard only). Developer and Express are free.
What’s the minimum number of core licenses?
Four per physical processor, or four per virtual machine when licensing VMs individually. Core licenses are sold in 2-core packs.
Do I need CALs with per-core licensing?
No. Per-core licensing covers unlimited users. CALs only apply to the Server + CAL model.
What’s the database size limit in SQL Server Express?
10 GB per database.
Can I use SQL Server Developer edition in production?
No. Developer is licensed for development and testing only.
Is Standard edition enough for my business?
For most small and mid-sized workloads, yes. Standard handles up to 24 cores and 128 GB of buffer pool memory per instance.
