SQL Server Web edition is the edition most web applications should be running and the one most buyers have never seen priced, because Microsoft does not sell it to end customers at all. It exists only inside hosting providers' Services Provider License Agreement (SPLA) price lists, which is why it appears on a SQL Server hosting order form and nowhere on the Microsoft store. This guide explains what Web edition is, where its limits sit against Express and Standard, what Microsoft's hosting terms let it serve, why it is disappearing after SQL Server 2022, and what it costs per vCore on a hosted server.

What SQL Server Web edition is

Microsoft describes Web edition as "a low total-cost-of-ownership option for Web hosters and Web VAPs". In practice it is a full SQL Server Database Engine with the same storage engine, query optimiser, Query Store, columnstore, Always Encrypted, row-level security, temporal tables, SQL Server Agent and log shipping that Standard edition has, but with two deliberate restrictions:

Because Microsoft treats it as a hosting product, the licence has no retail SKU, no volume-licensing SKU and no MSDN or Visual Studio channel. A hosting provider rents it to you per core, each month, as part of the server. When you leave, the licence goes with the server. That single fact explains most of the confusion around it.

Web edition against Express and Standard

The three editions most hosted applications choose between differ far more in their ceilings than in their features. The limits below are Microsoft's published figures for SQL Server 2022.

EditionCompute a single instance will useBuffer poolMax database sizeLicenceTypical use
ExpressLesser of 1 socket or 4 cores1,410 MB10 GB per databaseFreeSmall sites, development, embedded databases
WebLesser of 4 sockets or 16 cores64 GB524 PBSPLA only, per core, monthlyPublic websites, SaaS front ends, APIs, e-commerce
StandardLesser of 4 sockets or 24 cores128 GB524 PBRetail, volume, SPLA; per core or server + CALLine-of-business, ERP, internal applications, Basic Availability Groups
EnterpriseOperating-system maximumOperating-system maximum524 PBRetail, volume, SPLA; per coreAvailability groups with several replicas, online index operations, very large databases

Three differences matter in day-to-day operation. Web edition has no backup compression and no encrypted backups, so a Web edition backup is larger on disk and must be protected by the storage underneath it rather than by SQL Server itself. It has no Transparent Data Encryption, which some compliance checklists ask for at the database layer. And it has no Always On failover cluster instances or availability groups, so redundancy comes from the platform: on a managed cloud dedicated server that is the Proxmox HA cluster restarting the virtual machine on another node, not a second SQL Server replica.

What Web edition does have is everything a web application normally asks of a database: full-text search, Query Store, columnstore indexes, In-Memory OLTP, partitioning, data compression, SQL Server Agent for scheduled jobs, Database Mail and log shipping. For a shop, a booking system or a SaaS product's main database, the feature list is rarely the reason to buy Standard. The 64 GB buffer pool, the 16-core ceiling and the use restriction are.

The public web workload rule, with examples

The Services Provider Use Rights restrict Web edition to "public and Internet-accessible Web pages, Web sites, Web applications and Web services". Microsoft's own one-line summary is that Web edition may not be used to support line-of-business applications. The wording is read on 2 November 2026 and changes rarely, but confirm the current text with your reseller before relying on it.

Uses that fit

Uses that do not fit

The grey area is a public site with a staff back office. A shop's staff editing orders in the same database the public buys from is the normal shape of a web application and is treated as such. A system where the public-facing part is a thin front end on what is really an internal application is not. If you are unsure, the honest answer is Standard edition, and the difference in licence cost is often smaller than the time spent arguing the point. Our ERP hosting page covers the Standard edition route for line-of-business systems.

Why Web edition is SPLA-only, and what changes after SQL Server 2022

SPLA is Microsoft's licensing programme for service providers who host Microsoft software for third parties. The provider reports usage monthly, pays Microsoft per core or per user for that month, and the customer never owns or holds a licence. Web edition was created for exactly this channel, which is why it has a price in the SPLA list and nowhere else. A customer cannot buy a Web edition licence, cannot bring one to a hosting provider, and cannot move one between providers; what moves is the database, restored onto another provider's Web edition instance.

Two consequences follow. First, if you ever want to run the same database on your own hardware or in a hyperscaler under your own licence, it has to become Standard edition, because Standard is the smallest edition you can own. Second, the price you pay is set by the provider's SPLA cost plus margin, so it varies by provider and moves when Microsoft's price list moves. The SPLA hosting page explains how MassiveGRID handles the reporting and the monthly billing.

The bigger change is upstream. Microsoft's editions page for SQL Server 2022, read on 2 November 2026, states that "Web edition isn't available in SQL Server 2025 (17.x) and later versions". SQL Server 2022 is therefore the last version with a Web edition, and SQL Server 2022 is in mainstream support until 11 January 2028 and extended support until 11 January 2033 (Microsoft's lifecycle page, same date). A Web edition deployment made today has a long runway, but the edition you move to next will be Standard, or Express if the database is small enough, since Microsoft also folded the Advanced Services features (full-text search, Reporting Services) into the free Express edition from SQL Server 2025. Plan the eventual move now: keep database sizes and memory needs in view, and avoid features that Standard has but Express does not if you expect to drop down rather than up.

What Web edition costs on a hosted server

On a MassiveGRID SQL Server host, which is a Managed Cloud Dedicated Server with reserved vCores, the licences are priced per vCore per month and billed with the server. The Linux or evaluation rate is $18.75 per vCore, Windows Server Standard adds $6.00 and the SQL Server Web edition a further $8.50, so a Windows plus SQL Server Web vCore costs $33.25. RAM is $2.00 per GB and NVMe $0.03 per GB whichever licence you pick. The same figures apply in New York, London, Frankfurt and Singapore.

ConfigurationOf which SQL Server WebMonthly total with Windows and SQL WebFits
2 vCores, 8 GB RAM, 128 GB NVMe$17.00$86.34One site or application with a database of a few gigabytes
4 vCores, 16 GB, 256 GB$34.00$172.68A production web application and its reporting queries
8 vCores, 32 GB, 512 GB$68.00$345.36A SaaS database or several busy sites
16 vCores, 64 GB, 1 TB$136.00$690.72The Web edition ceiling: 16 cores and a 64 GB buffer pool

The managed price includes the operating system installation, patching, hardening, daily backups, 24/7 monitoring and the HA cluster, so the SQL Server Web line is a small part of the bill. On the Virtual Private Cloud order form, where you run your own virtual machines, the Web edition add-on is $7.50 per vCore and Windows Server Standard $3.50 per vCore on top of the pool price. Both are our SPLA rates and change when Microsoft's do.

Note Microsoft's four-core minimum: SQL Server under SPLA is reported in two-core packs with a four-core minimum per virtual machine, so a 2 vCore server is licensed as four cores. Ask before ordering a 2 vCore SQL Server host how the minimum is applied on the invoice; the configurator shows the per-vCore rate, and we will confirm the licensing line for a 2 vCore order in the ticket.

When to move from Web to Standard

Four signals mean Web edition is no longer the right choice:

  1. The workload changes character. The moment the database primarily serves your own staff rather than the public, the use restriction applies and Standard is required regardless of size.
  2. The working set outgrows 64 GB. If the hot data no longer fits the buffer pool, Web edition will read from NVMe on every query it cannot cache. Fast storage hides this for a while; a rising page life expectancy problem does not go away.
  3. You need a feature Web lacks. Backup compression and encrypted backups, Transparent Data Encryption, Basic Availability Groups with a second replica, or failover cluster instances all require Standard.
  4. You want to own the licence. Under the Flexible Virtualization Benefit, a Standard licence with active Software Assurance can be brought to a hosting provider that is not a Listed Provider. There is no such path for Web edition, because there is no Web edition licence to own.

Moving up is an edition upgrade, not a migration: SQL Server Setup upgrades a Web instance to Standard in place, and the databases do not change. On a managed server we do the upgrade in the maintenance window you choose. The SQL Server Standard hosting page lists how the Standard licence is priced, where it is orderable online and where it is quoted.

Frequently Asked Questions

Can I buy a SQL Server Web edition licence myself?

No. Web edition has no retail or volume-licensing SKU. It is available only through hosting providers under Microsoft's Services Provider License Agreement, priced per core and billed monthly with the server. If you want to own the licence, Standard is the smallest edition you can buy.

Is Web edition allowed for an internal application if my staff reach it over the internet?

No. The Services Provider Use Rights limit Web edition to public, internet-accessible web pages, sites, applications and services, and exclude line-of-business applications. Staff using a system over the internet does not make it public. Use Standard edition for internal applications, or ask us for a quote.

What are the limits of SQL Server 2022 Web edition?

A single instance uses at most the lesser of 4 sockets or 16 cores and 64 GB of RAM for the buffer pool, and databases can grow to 524 PB. Web edition has no backup compression, encrypted backups, Transparent Data Encryption, failover cluster instances or availability groups.

Will there be a Web edition of SQL Server 2025?

No. Microsoft's editions documentation states that Web edition is not available in SQL Server 2025 and later. SQL Server 2022 is the last version with a Web edition and stays in extended support until January 2033, so existing deployments have time, but the next edition will be Standard or Express.

How much does SQL Server Web edition cost at MassiveGRID?

On the managed SQL Server host it is $8.50 per vCore per month on top of the Windows Server rate, so 2 vCores, 8 GB and 128 GB with both licences cost $86.34 a month and 4 vCores, 16 GB and 256 GB cost $172.68. On the Virtual Private Cloud order form the add-on is $7.50 per vCore. Both are our SPLA rates and move when Microsoft's do.

SQL Server Web edition included, from $86.34 a month

The MassiveGRID SQL Server host is a managed cloud dedicated server with reserved vCores and NVMe, Windows Server Standard and SQL Server Web licensed per vCore under our SPLA agreement, daily backups, 24/7 monitoring and HA failover, in New York, London, Frankfurt or Singapore. Need Standard for an internal application? Ask for a quote.

Configure a SQL Server Host

Further Reading