Quick answer
SQL Server hosting licensing runs through three primary mechanisms — SPLA core licensing reported monthly by the hoster, customer BYOL with active SA (via AHB into Azure or FVB into non-listed-provider IaaS), and Azure Arc-enabled SQL Server billed PAYG through the Azure subscription. For customers with SA, BYOL is almost always 55-75% cheaper than SPLA on the Microsoft cost layer. For customers without SA, the answer depends on workload life, edition mix, and provider. The most expensive failure mode in 2026 audits is SQL Server Enterprise BYOL on AWS or Google Cloud without FVB-equivalent documentation — assume it will be audited within 24 months.
On this page
- Why SQL Server hosting licensing deserves its own pillar
- The three SQL Server hosting mechanisms
- SPLA SQL Server: monthly core reporting
- BYOL with SA: AHB and FVB economics
- Azure Arc-enabled SQL: PAYG and managed billing
- Edition economics: Standard vs Enterprise vs Web
- Unlimited virtualization with Enterprise + SA
- Listed-provider impact on SQL hosting
- Audit patterns specific to hosted SQL Server
- A practical cost model: one workload, three mechanisms
- Major 2026 changes affecting SQL Server hosting
Why SQL Server hosting licensing deserves its own pillar
SQL Server is the highest unit-cost Microsoft product in most enterprise hosting estates. Per-core licensing at Enterprise edition runs 10x the per-core cost of Windows Server. The compounding effect of getting SQL Server hosting licensing wrong — over-declaring AHB, mis-classifying SPLA reports, or BYOL into a listed provider without rights — produces findings two and three orders of magnitude larger than the equivalent Windows Server mistake.
Compounding the unit-cost pressure, SQL Server has the most complex per-product hosting rules in the Microsoft estate: per-edition rules differ; unlimited-virtualization rights differ; AHB stacking with hosted infrastructure differs; the listed-provider boundary applies differently to Standard vs Enterprise. A configuration that is compliant for SQL Server Standard may be non-compliant for the same workload at SQL Server Enterprise on the same host.
For the broader IaaS-licensing context this guide sits inside, see our Microsoft IaaS Licensing Guide.
The three SQL Server hosting mechanisms
| Mechanism | Who pays | Reporting cadence | Typical use |
|---|---|---|---|
| SPLA SQL Server (per core, monthly) | Hoster (passes to customer) | Monthly | Managed-services-provider hosting; customers without their own SA |
| BYOL with SA (via AHB / FVB) | Customer directly (EA / MPSA) | Annual; AHB inventory | Customers with active SA on SQL Server moving into hosted environments |
| Azure Arc-enabled SQL (PAYG) | Customer directly (Azure subscription) | Per-core, per-hour on Azure bill | Short-lived, burst, or hybrid SQL workloads where conventional licensing is over-priced for actual use |
Most enterprise SQL Server hosting estates use more than one mechanism in parallel — SPLA for newer or non-SA-covered workloads, BYOL for the SA-protected backbone, and increasingly Arc-PAYG for dev/test or burst workloads. The optimization conversation is which workload should be on which mechanism, not which mechanism wins in the abstract.
SPLA SQL Server: monthly core reporting
SPLA SQL Server is reported per physical core on the host (or per virtual core in some constrained configurations) on the hoster's monthly SPLA report. The mechanics:
- Per-core monthly fee. Reported per physical core of the host running SQL Server, with a minimum core count per host (typically 4 cores per processor, 8 per server) that applies even if actual usage is lower.
- Edition matters. SPLA SQL Standard and Enterprise are priced very differently per core. Enterprise SPLA is roughly 4x Standard per core.
- Virtualization treatment. SPLA SQL on a VM is typically reported per vCPU assigned to the VM, with minimum-core constraints per VM. Unlimited-virtualization rights work differently under SPLA than under BYOL with SA.
- Customer-of-record question. Under SPLA the hoster is the customer-of-record; the end customer does not need their own SQL Server entitlement.
SPLA SQL is the mechanism for customers who do not have their own SQL Server SA entitlement and are not buying one as part of the hosting engagement. It is the dominant mechanism in healthcare-ISV, financial-services-managed-hosting, and vertical SaaS contexts where the hoster's customers do not have direct Microsoft EAs.
BYOL with SA: AHB and FVB economics
BYOL with SA is the cheapest SQL hosting mechanism for customers who have it. The two channels:
AHB into Azure. For customers with SA-qualified SQL Server, Azure Hybrid Benefit allows the entitlement to flow into Azure VMs, Azure SQL Managed Instance, and Azure SQL Database without paying for SQL Server software on top of Azure compute. The savings on the SQL Server cost layer are substantial — typically 55-75% relative to PAYG SQL on Azure. For Azure SQL Managed Instance, AHB can also unlock specific tier-pricing benefits.
FVB into non-listed-provider IaaS. The 2022 Flexible Virtualization Benefit extended BYOL for SA-qualified SQL Server into non-listed-provider hosted environments under specific conditions. A customer with SA can deploy SQL Server VMs on a colo, a regional cloud, or a non-listed-provider managed-services hoster without the historic "dedicated infrastructure" requirement that pre-2022 BYOL imposed.
Both paths require the same documentation: active SA on the underlying entitlement, correct per-core mapping from entitlement to deployment, and provider-eligibility documentation. The 2026 audit pattern is AHB / FVB declarations that exceed the per-core entitlement available.
Azure Arc-enabled SQL: PAYG and managed billing
Azure Arc-enabled SQL Server is an on-premises or hosted SQL Server instance connected to Azure for centralized management, billing, and Azure-native feature delivery. Licensing options on Arc-connected instances:
- PAYG SQL Server via Azure subscription. Per-core, per-hour billing on the Azure bill, no SA required. Uniquely valuable for short-lived or burst SQL workloads where conventional core licensing is over-priced for actual hours of use.
- BYOL via AHB declaration on the Arc-connected instance. Customer with SA-qualified SQL Server declares AHB on the Arc instance; no Microsoft software cost on the Azure bill; underlying SA must be live.
- Conventional SQL Server licensing. The Arc connection is purely management; the SQL Server license is held under EA / MPSA / SPLA in the normal way; Arc adds management value without changing the licensing posture.
The PAYG-via-Arc option has become materially more competitive through 2025-2026 as Microsoft has adjusted Arc-PAYG rate cards and improved the management integration. For dev/test and burst SQL workloads it is increasingly the right answer, not the niche answer.
Edition economics: Standard vs Enterprise vs Web
SQL Server hosting cost is dominated by edition selection. The three editions in current hosting contexts:
| Edition | Per-core cost (relative) | Hosting use case |
|---|---|---|
| SQL Server Web | ~0.15x Standard | SPLA-only; web-facing workloads with restricted use rights (no internal business applications) |
| SQL Server Standard | 1x baseline | General-purpose SQL workloads; per-VM or per-host licensing |
| SQL Server Enterprise | ~4x Standard | Mission-critical SQL workloads; unlocks unlimited virtualization on fully-licensed hosts with SA |
The hosting decision is rarely "Web vs Standard vs Enterprise on cost alone" — it is "what feature set does the workload actually require, what is the consolidation density we can achieve, and does Enterprise+SA unlimited virtualization beat Standard at the target consolidation ratio?"
Unlimited virtualization with Enterprise + SA
SQL Server Enterprise with active SA grants unlimited-virtualization rights on a fully-licensed physical host: license every physical core on the host with SQL Server Enterprise + SA, and run unlimited SQL Server VMs on that host without additional per-VM licensing. This is the single most important density lever in SQL Server hosting.
Practical implications:
- Cost crossover. Above ~6-8 SQL VMs per host, Enterprise+SA unlimited virtualization typically beats Standard per-VM licensing on the same hardware. The exact crossover depends on edition pricing, SA cost, and density.
- BYOL into AHB. Customers with Enterprise+SA can use AHB to bring unlimited-virtualization rights into Azure on dedicated-host configurations.
- BYOL into FVB. Same principle applies to non-listed-provider hosted environments under FVB. Listed-provider rules constrain the unlimited-virt rights — validate per provider.
- Documentation. Unlimited virtualization claims require physical-host licensing inventory; auditors will ask for it.
Reduced annual SQL Server hosting cost by $4.2M (47%) for a healthcare ISV hoster running 9,200 SQL cores across SPLA + BYOL. The remediation: converted 60% of the SPLA-reported SQL Standard cores to FVB BYOL where the underlying customer had SA, converted the remaining high-density SPLA Standard hosts to Enterprise+SA unlimited-virtualization at 12-VM-per-host density, and rebuilt the AHB inventory to remove 1,400 over-declared cores. The 6-month engagement also resolved a Microsoft Verification scope letter that was active at start of work, at no additional finding cost.
Listed-provider impact on SQL hosting
SQL Server BYOL into listed providers (AWS, Google Cloud, Alibaba and others on the rotating list) is the single highest-frequency 2025-2026 audit finding pattern in our enterprise SQL data.
The rules in current form:
- SQL Server Standard with SA. Some BYOL paths into listed providers exist with specific rights documentation. Default assumption: more constrained than non-listed-provider FVB.
- SQL Server Enterprise with SA. Different and more limited BYOL paths into listed providers. Unlimited-virtualization rights typically do not extend into listed-provider hosted environments without explicit additional rights.
- AHB on listed providers. Requires explicit attestation and audit-ready documentation per Microsoft Verification methodology.
The remediation pattern for findings in this space is forced revert to PAYG SQL Server pricing on the impacted VMs, with backdated true-up across the audit window. Findings in the $500K-$5M range are typical for enterprise SQL portfolios that BYOL into listed providers without rights documentation. See Microsoft Audit Defense for the engagement that prevents and resolves these.
Audit patterns specific to hosted SQL Server
Five audit patterns dominate hosted-SQL findings:
- AHB over-declaration. More VMs flagged AHB-eligible than the per-core SA entitlement supports. The single most frequent finding pattern.
- Listed-provider BYOL without rights documentation. SQL Server Enterprise BYOL on AWS or Google Cloud without FVB-equivalent rights. Highest unit-value findings.
- Unlimited-virtualization claims without fully-licensed-host evidence. Enterprise+SA unlimited-virt is conditional on every physical core being licensed; partial licensing breaks the right.
- SPLA SQL Web mis-application. Web edition is restricted to web-facing workloads with no internal business application use; misuse triggers reclassification.
- Per-vCPU vs per-physical-core mismatches under SPLA reporting on virtualized hosts.
A practical cost model: one workload, three mechanisms
A 100-VM SQL Server estate, 4 cores per VM, mixed Standard / Enterprise, mid-market hosting. The Microsoft cost layer (illustrative 2026 rates, before negotiation) varies as follows:
| Mechanism | Indicative annual SQL Server cost | Conditions |
|---|---|---|
| SPLA SQL Standard core licensing | ~$420K-$580K | Hoster pays monthly; passes to customer; no customer SA required |
| BYOL Standard with SA via FVB (non-listed provider) | ~$160K-$230K | Customer SA must be active; provider must not be listed |
| SPLA SQL Enterprise core licensing | ~$1.7M-$2.3M | SPLA Enterprise per core; no virtualization-unlimited unless dedicated host |
| BYOL Enterprise with SA + unlimited virt (10 VMs per host) | ~$380K-$520K | Customer SA active; fully-licensed physical hosts; per-host density of 10+ VMs |
| Azure Arc-enabled SQL PAYG (dev/test, 40% utilization) | ~$150K-$210K | For workloads with non-continuous SQL usage; PAYG matches actual hours |
The ranges are illustrative, not contractual. The pattern is consistent: the spread between the highest-cost and lowest-cost compliant mechanism for the same workload is 3-5x. Most enterprise SQL hosting estates we engage with have at least one major workload running on the wrong mechanism for its entitlement profile.
Major 2026 changes affecting SQL Server hosting
Four named 2026 changes shape the SQL Server hosting conversation:
1. Continued AHB-overdeclaration verification. Microsoft Verification has prioritized AHB-overdeclaration audits on SQL Server through 2025-2026. The remediation pattern is forced PAYG revert with backdated true-up.
2. Azure Arc-enabled SQL Server pricing competitiveness. Arc-PAYG SQL pricing has narrowed the gap with conventional licensing for burst and dev/test workloads. The 2026 right answer for these workloads is often Arc-PAYG, not conventional EA.
3. Listed-provider BYOL boundary moves. The listed-provider rule set continues to evolve quarterly. Validate at the start of any SQL hosting engagement on AWS or Google Cloud.
4. AI and Fabric-attached SQL workloads. SQL Server workloads attached to Fabric (Microsoft's analytics platform) or AI agent infrastructures have new entitlement scope clarifications through 2025-2026; validate before assuming standard hosting rights cover the workload.
For the broader 2026 licensing context, see our 2026 Microsoft Licensing Changes rollup and the companion Microsoft IaaS Licensing Guide.
SQL Server hosting licensing review — typical 40-55% cost reduction
500+ Microsoft engagements. $2.1B managed. 32% average reduction. SPLA SQL + BYOL + Arc-PAYG inventoried, optimized, and audit-defended together. Buyer-side only.
Get a SQL Hosting Review License Optimization ServiceFrequently asked questions about SQL Server hosting licensing
What's the cheapest way to license SQL Server in a hosted environment?
For customers with active SA on SQL Server, BYOL via AHB into Azure or FVB into a non-listed-provider IaaS is almost always cheapest — 55-75% lower than SPLA SQL Server core licensing for the same workload. For customers without SA, the picture depends on entitlement portfolio, hosting provider, and expected workload life.
How does SQL Server Enterprise vs Standard change hosting economics?
Enormously. Enterprise is roughly 4x per core but unlocks unlimited virtualization on fully-licensed hosts with SA. A single 8-core Enterprise license with SA on a 32-core host can run unlimited SQL VMs on that host. Enterprise+SA+unlimited-virt economics often beat Standard at scale.
What is Azure Arc-enabled SQL Server and how is it licensed?
Arc-enabled SQL is an on-premises or hosted SQL instance connected to Azure for management and billing. Options: PAYG via Azure subscription (per-core, per-hour, no SA needed), BYOL via AHB declaration, or conventional EA / MPSA licensing reported separately. Arc-PAYG is uniquely valuable for burst or dev/test SQL workloads.
Do listed-provider rules affect SQL Server hosting?
Yes. SQL BYOL on listed providers (AWS, Google Cloud, Alibaba and others) is more constrained than on non-listed providers. SQL Standard with SA has some BYOL paths; SQL Enterprise with SA has more limited paths. AHB on listed providers requires explicit attestation. The most expensive enterprise SQL hosting findings in 2026 are listed-provider BYOL without documentation.
How are SQL Server hosting CALs counted?
In current hosting contexts SQL is licensed per core, not per user. The legacy server+CAL model exists in constrained scenarios but is rarely the right answer for hosting. Per-core is broadly assumed for SPLA, BYOL, and Arc-PAYG.
What 2026 changes most affect SQL Server hosting licensing?
Four pressure points: AHB-overdeclaration verification, Arc-PAYG pricing competitiveness, listed-provider BYOL boundary moves, and AI / Fabric-attached SQL workload entitlement clarifications. Plan SQL hosting renewals with these in view.
Run a SQL Server hosting review before the next AHB-verification cycle
30-minute scoping call. Fixed-fee engagement proposals within 5 business days. SPLA + BYOL + Arc-PAYG inventoried, optimized, audit-defended. Independent, senior-led.
Book a 30-Minute Call License Optimization Service