SQL Server licensing punishes the inattentive. Cores, CALs, Software Assurance, virtualization, HA topology, and the cloud overlay each carry rules that Microsoft audits use to score gaps.
SQL Server licensing punishes the inattentive. Cores, CALs, virtualization, HA secondaries, and cloud all carry rules that audits exploit.
SQL Server licensing has stayed structurally consistent for a decade. The detail has not. Each release adds rules that audits use to score gaps.
This pillar maps the licensing model end to end. Editions, metrics, Software Assurance, virtualization, HA and DR, cloud overlay, and audit posture.
Read the related Microsoft knowledge hub and the Microsoft advisory service for the wider context.
Enterprise edition fits mission critical OLTP, large analytics workloads, and any deployment needing Always On Availability Groups with multiple secondaries.
Standard edition fits departmental OLTP, smaller analytics, and most line of business databases under 128 GB.
Standard edition caps memory at 128 GB and TempDB at limited core counts. Beyond those limits, Enterprise is the only option.
Many buyers run Enterprise where Standard suffices. The audit usually surfaces the opposite, Standard running Enterprise features.
Per core licensing sells in two core packs. Each pack covers two physical or virtual cores. The minimum per server is four cores.
Per core licensing covers unlimited users. The metric scales by hardware, not by population.
Per core licensing in virtualized environments licenses the assigned virtual cores per VM. Minimum four cores per VM.
Fully licensing the host unlocks unlimited VMs running SQL Server on that host. Software Assurance is required.
SQL Server licensing decision matrix
| Scenario | Metric | Edition fit | SA requirement |
|---|---|---|---|
| Mission critical OLTP | Per core | Enterprise | Required |
| Departmental OLTP | Per core or Server CAL | Standard | Recommended |
| Analytics workload | Per core | Enterprise | Required |
| Azure SQL Managed Instance | Azure SKU + AHB | Enterprise or Standard | Required for AHB |
| Dev / test | Developer edition | Developer | Not applicable |
| Reporting layer | Per core or Server CAL | Standard | Recommended |
SA cost is approximately 25 percent of license cost per year. SA pays off if the customer plans a version upgrade, runs Azure SQL, or relies on HA failover.
Most enterprise SQL Server estates need SA. The exception is fixed legacy estates with no upgrade or cloud trajectory.
SA renews on the EA cycle. Lapse and reinstatement is expensive, typically 1.5 to 2 times the SA price.
Buyers should map SA on every SQL Server license at renewal and decide line by line.
AHB applies SA covered SQL Server licenses against Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure VM.
Cost reduction runs 30 to 55 percent compared to license included Azure SKUs. The discount applies for the full license term.
SQL Server 2022 added pay as you go billing through Azure Arc. Customers can run SQL Server on premises and pay per vCore per hour.
The model fits variable workloads. Fixed estates rarely benefit. The metric is reported through Arc telemetry, which audits can read.
The standard Microsoft pitch is that Software Assurance pays back through version upgrade rights and is therefore a default add on for every SQL Server estate. We disagree. In roughly five out of eight SQL Server estates we have audited, the SA premium exceeded the version upgrade value across the term because most enterprises run prior version SQL Server for five to seven years before upgrading. The SA value lives in the disaster recovery rights, Azure Hybrid Benefit eligibility, and license mobility. Buy SA against those three specific use cases, not as an undifferentiated default. The economics often favor SA on production cores and skip SA on test or development cores.
Source: Redress Compliance advisory engagement file, 2024 to 2025.
SQL Server compliance is not a hardware count. It is a posture. The buyer who anchors HA topology, edition usage, and cloud overlay wins the audit.
One passive secondary instance is free under Software Assurance. The secondary must not serve queries, accept backups, or run any active workload.
The rule is the most common audit finding. Readable secondaries are not passive.
Cold DR is free under SA. Warm DR with no active workload is also free.
Hot DR with active queries is not free. Each hot DR instance needs full licensing.
SQL Server audits typically use MAP Toolkit or SCCM extraction to inventory installed instances and core counts.
The audit reconciles inventory against EA entitlement. The gap surfaces as a true up bill at list.
Buyer side defense rests on a current Effective License Position. Inventory by edition, by core count, by HA topology.
Anchor the ELP every six months. Run a self audit before Microsoft does. The Microsoft EA renewal is the optimal window.
SQL Server is licensed per core or Server plus CAL. Enterprise edition is per core only. Standard edition supports both. Each VM running SQL Server needs core licenses sized to virtual cores, minimum four.
Yes, one passive failover secondary is free under SA. The secondary must not serve queries, run backups, or accept any active workload. Readable secondaries break the rule.
AHB applies only to SQL Server licenses with active Software Assurance. The benefit covers Azure SQL Database, Azure SQL Managed Instance, and SQL Server on Azure VM.
Yes, SA covered licenses qualify for License Mobility on AWS dedicated hosts or shared tenancy with specific conditions. Microsoft maintains an authorized provider list. Off list providers do not qualify.
Standard caps memory at 128 GB and limits TempDB scale. Enterprise unlocks full feature set including Always On Availability Groups with multiple secondaries, partitioning, and advanced compression.
SQL Server audits surface gaps in approximately 75 percent of enterprise estates. Common gaps run between 8 and 22 percent of installed entitlement. The most common finding is readable secondaries treated as passive.
Redress runs SQL Server advisory inside the Vendor Shield subscription and Microsoft Renewal Program. Engagements cover ELP build, audit defense, AHB math, and SA renewal decisioning.
Open with an inventory and entitlement baseline before any vendor conversation. Pull trailing twelve months of usage data, score it against contracted scope, and document the gap. The single most common reason buyers leave money on the table is opening the negotiation without a defensible baseline. The buyer side calendar starts at 270 days out, not at 60.
Microsoft renewal moves, EA framework, M365 SKU framework, Copilot framework, and buyer side moves across the full Microsoft estate.
Used across more than five hundred enterprise engagements. Independent. Buyer side. Built for procurement leaders running the next renewal cycle.
SQL Server licensing is a posture, not a count. Edition fit, HA topology, and the cloud overlay carry more value than any rate discount Microsoft ever offered.
500+ enterprise clients. 11 vendor practices. Gartner recognized. One conversation can change what you pay for the next three years.
SQL Server, M365, Azure, EA, and Copilot lessons from every Microsoft engagement we run.
