Software Assurance (SA) is the most consequential add-on in Microsoft's SQL Server licensing portfolio, yet most organisations underutilise its benefits by 40 to 60%. SA unlocks version upgrade rights, licence mobility across servers and cloud providers, unlimited virtualisation on Enterprise Edition, passive failover for disaster recovery at no additional cost, Azure Hybrid Benefit for 40 to 69% cloud savings, per-VM licensing in virtualised environments, and step-up rights from Standard to Enterprise.
Software Assurance is an annual maintenance programme purchased with (or added to) SQL Server licences through Microsoft Volume Licensing. The typical cost is approximately 25% of the licence price per year. For SQL Server Enterprise at $14,256 per core, SA costs roughly $3,564 per core annually.
SA delivers: version upgrade rights to new SQL Server releases, licence mobility across servers and cloud providers, unlimited virtualisation on Enterprise Edition, passive failover rights for DR, Azure Hybrid Benefit for cloud cost reduction, per-VM licensing in virtualised environments (SQL 2022+), step-up rights from Standard to Enterprise, and planning services, training vouchers, and support incidents. Most organisations actively use 2 to 3 of these. The goal is to activate all applicable benefits.
SA pays for itself when the combined value of benefits used exceeds the annual SA fee. For a 100-core SQL Enterprise deployment: SA costs approximately $356K/year. If you use AHB on 50 Azure VMs (saving $750K/year), exercise passive failover (avoiding $713K in DR licences), and upgrade from SQL 2019 to 2022 (avoiding $1.4M in new licences), the benefit exceeds $2.8M against $356K in SA cost. An 8x return. Even using just one major benefit typically justifies SA renewal.
If you purchased SQL Server 2019 with SA and Microsoft releases SQL Server 2022, you can upgrade all SA-covered instances to 2022 at no additional licence cost. Over a typical 3 to 5 year upgrade cycle, SA's cumulative annual cost is significantly less than purchasing new licences. For 100 cores of Enterprise: new licence purchase would cost $1.4M; three years of SA costs $1.07M, a $350K saving plus you retain the ongoing benefits.
If your SA is expiring and a new SQL Server version has been announced, upgrade before SA expires. Once you upgrade under active SA, you retain the perpetual licence for that version even if you subsequently let SA lapse. Conversely, if SA lapses before you upgrade, you are permanently locked to the version you had when SA was last active. Re-acquiring SA after a lapse typically requires repurchasing the underlying licence at current list price.
SA-covered licences can be reassigned to any server within the server farm at any time, with no 90-day waiting period. A "server farm" is servers in the same data centre or two data centres in the same time zone region. This is essential for virtualised environments: VMs with SQL Server can migrate between hosts via vMotion or Live Migration without compliance violations. For dynamic environments with automated VM placement (DRS, SCVMM), SA licence mobility is functionally mandatory.
SA enables Bring Your Own Licence to cloud providers: deploy SQL Server on AWS EC2 (dedicated tenancy, requires Licence Mobility Verification Form), Azure VMs (via Azure Hybrid Benefit), or other authorised hosting providers. Idle on-premises licences can be redeployed to cloud infrastructure, avoiding the cloud provider's SQL Server surcharge. For hybrid and cloudburst scenarios, licence mobility provides the legal framework to move workloads between on-premises and cloud as demand fluctuates.
The highest-impact SA benefit for heavily virtualised environments: SQL Server Enterprise with SA grants unlimited virtualisation rights on a fully licensed host.
| Scenario | Without SA | With Enterprise + SA | Savings |
|---|---|---|---|
| 16-core host, 10 SQL VMs (4 vCPU each) | 40 core licences per-VM ($570K Ent) | 16 core licences per-host ($228K Ent) | $342K (60%) |
| 32-core host, 20 SQL VMs (4 vCPU each) | 80 core licences per-VM ($1.14M Ent) | 32 core licences per-host ($456K Ent) | $684K (60%) |
| 3-host cluster (48 cores), 30 SQL VMs | 120 core licences ($1.71M Ent) | 48 core licences ($684K Ent) | $1.03M (60%) |
Unlimited virtualisation with Enterprise + SA means new SQL VMs on licensed hosts require zero incremental licences, eliminating true-up exposure and provisioning delays. Consolidate SQL workloads onto fewer, fully licensed hosts and run any number of instances. The ROI compounds as VM density increases. Every additional VM on a licensed host is effectively free.
SA provides the right to operate one passive secondary SQL Server instance for high availability and disaster recovery at no additional licence cost. The secondary can receive data through log shipping, database mirroring, or Always On Availability Groups, and can be used for brief failover testing and maintenance patching. It cannot serve read queries, run reports, or process any production workload during normal operation. In Always On, the secondary must have ALLOW_CONNECTIONS = NO to qualify as passive. Setting it to READ_ONLY or ALL makes it active, requiring its own licence. This single benefit effectively doubles the value of your licence.
SA extends passive failover rights to Azure: you can run a passive SQL Server VM in Azure as your DR replica without additional licensing. The Azure VM uses AHB for the compute cost (paying only base Linux rate), and the passive failover right covers the SQL licence. For organisations with SA-covered SQL Enterprise: the combination of AHB + passive failover in Azure can provide enterprise-grade DR for under $5K/year per instance in Azure infrastructure costs alone, compared to $50K+ for a physical DR site with separate licences.
AHB is SA's highest-value benefit for organisations adopting Azure. Each SA-covered SQL Server core licence offsets Azure SQL pricing by removing the SQL licence component from the hourly rate.
| Azure Resource | Enterprise Core Mapping | PAYG Rate | AHB Rate | Savings |
|---|---|---|---|---|
| SQL Server on Azure VM (D8s_v5) | 8 Enterprise cores to 8 vCPUs | $2.50/hr | $0.77/hr | 69% |
| Azure SQL Managed Instance (8 vCore BC) | 8 Enterprise cores to 8 vCores | $5.40/hr | $2.16/hr | 60% |
| Azure SQL Database (8 vCore GP) | 2 Enterprise cores to 8 vCores GP | $1.84/hr | $0.92/hr | 50% |
| Annual impact (10 D8s_v5 VMs) | $219K/yr | $67K/yr | $152K/yr saved |
AHB is a billing toggle: you declare it when creating or modifying an Azure resource. No migration, no configuration change, no downtime. Yet in our advisory engagements, 30 to 50% of eligible Azure SQL resources are running at full PAYG rates because the AHB toggle was not activated. The fix takes seconds per resource: Azure portal, select the SQL resource, change the licence type to "Azure Hybrid Benefit". For organisations with 50+ Azure SQL resources, this single action can save $200K to $500K annually. SAM teams should audit Azure billing monthly for SQL resources not using AHB.
Starting with SQL Server 2022, SA is required for per-VM licensing in virtualised environments. Previously, you could licence individual SQL VMs with perpetual licences (no SA) as long as you observed the 90-day reassignment rule. SQL Server 2022 changed this: per-VM licensing now requires active SA on every licence assigned to a VM. If SA lapses, those per-VM licences become invalid for virtual deployment. SA is now a baseline requirement, not an optional add-on, for virtualised SQL Server 2022+ deployments.
SA enables step-up licensing: upgrade from Standard Edition to Enterprise by paying only the price difference (plus SA on the difference), rather than purchasing a full Enterprise licence. For a 16-core server: full Enterprise purchase is $228K; step-up from Standard (if already owned) is approximately $165K, saving $63K per server. This is valuable when workloads grow to require Enterprise features (Always On AGs, unlimited virtualisation, data compression). Plan step-ups at EA renewal for maximum negotiation leverage.
SA includes Planning Services days (Microsoft or partner consultants help plan deployments/migrations), training vouchers for Microsoft courses, and support incidents for critical issues. These are frequently unused, but their value is real. Use Planning Services for SQL Server upgrade roadmaps or cloud migration assessments. Training vouchers keep DBAs current on licensing changes and new features. Support incidents provide direct Microsoft engineering assistance.
Renew SA when any of the following apply: you run SQL Server in virtualised environments (SA is mandatory for per-VM licensing and licence mobility), you use or plan to use Azure Hybrid Benefit, you anticipate upgrading to a newer SQL Server version within the SA period, you rely on passive failover rights for DR, or your SQL estate exceeds 50 cores (the cumulative benefits almost certainly exceed the cost). For most enterprises, maintaining SA is the default recommendation.
Lapsing SA may be justified when: SQL Server runs on physical servers only (no virtualisation, no mobility needed), you do not plan to upgrade versions and are satisfied with the current release, you have no Azure or cloud deployment plans, and you do not use passive failover (or are willing to licence DR servers separately). These conditions are rare in modern enterprises. Before lapsing, calculate the cost of re-acquiring SA later (requires repurchasing the underlying licence at current list price). This "re-entry penalty" often exceeds several years of continued SA payments.
Audit AHB activation monthly: check every Azure SQL resource for AHB status. Unactivated AHB is the single most common waste in SQL Server cloud licensing. Map all passive failover instances: ensure every secondary that qualifies as passive is documented and configured correctly (ALLOW_CONNECTIONS = NO). Consolidate SQL VMs onto fully licensed Enterprise + SA hosts to leverage unlimited virtualisation. Upgrade to the latest version before SA expires: lock in the newest release. Use Planning Services and training vouchers before they expire. Review step-up opportunities at every EA renewal.
Approximately 25% of the licence price per year. For SQL Server Enterprise at $14,256 per 2-core pack, SA costs roughly $3,564 per 2-core pack annually. For a 16-core server on Enterprise, the annual SA cost is approximately $28,500. SA is purchased through Microsoft Volume Licensing (EA, EAS, or Select Plus) and typically renews at EA anniversary.
It depends on your deployment model. For heavily virtualised environments, unlimited virtualisation (Enterprise + SA) typically delivers the highest ROI, saving 60%+ in licence costs by licensing hosts instead of individual VMs. For cloud-adopting organisations, Azure Hybrid Benefit delivers 40 to 69% savings on Azure SQL resources. For DR-dependent environments, passive failover rights effectively double the value of every licence. Most enterprises benefit from a combination of these.
You retain the perpetual licence for the SQL Server version you had when SA was last active, but you lose all SA benefits: no version upgrades, no licence mobility, no unlimited virtualisation, no passive failover rights, no AHB, and no per-VM licensing for SQL 2022+. Re-acquiring SA after a lapse typically requires repurchasing the underlying licence at current list price. This re-entry penalty often exceeds several years of continued SA payments. If SA is expiring, upgrade to the latest SQL Server version before it lapses.
Effectively yes. Starting with SQL Server 2022, per-VM licensing requires active SA on every licence assigned to a VM. Without SA, you must licence the entire physical host or move to a subscription model (CSP or Azure). This change makes SA functionally mandatory for any organisation running SQL 2022+ VMs without licensing the entire physical host. Combined with licence mobility requirements for dynamic VM environments, SA is now a baseline requirement for virtualised SQL Server deployments.
Each SA-covered SQL Server core licence offsets Azure SQL pricing by removing the SQL licence component from the hourly rate. You activate AHB by toggling a billing setting on each Azure SQL resource (no migration or configuration change required). Savings range from 40 to 69% depending on the Azure resource type. The most common waste: 30 to 50% of eligible Azure SQL resources run at full PAYG rates because the AHB toggle was not activated. Audit monthly. See SQL Server Licensing Master Guide.
Yes. SA extends passive failover rights to Azure: you can run a passive SQL Server VM in Azure as your DR replica without additional SQL licensing. The Azure VM uses AHB for compute cost (paying only base rate), and the passive failover right covers the SQL licence. This makes Azure DR significantly cheaper than maintaining a second physical data centre. For SA-covered SQL Enterprise: AHB + passive failover in Azure can provide enterprise-grade DR for under $5K/year per instance in Azure infrastructure costs alone.
When you licence all physical cores on a host with SQL Server Enterprise + SA, you gain the right to run unlimited SQL Server instances in VMs on that host. A 16-core host with Enterprise + SA can run any number of SQL VMs (10, 20, 50) without additional licences. Without SA, each VM must be licensed individually based on its vCPU allocation. For a 16-core host running 10 four-vCPU VMs: without SA you need 40 core licences ($570K); with Enterprise + SA you need 16 core licences ($228K). Savings of 60%.
Redress Compliance provides independent Microsoft advisory for SQL Server licensing optimisation: SA benefit activation, AHB audit and activation, unlimited virtualisation strategy, licence mobility compliance, passive failover configuration review, EA renewal negotiation, and audit defence. We help enterprises extract full value from their SA investment while maintaining compliance. Complete vendor independence. No Microsoft partnerships, no resale commissions.
Microsoft Advisory ServicesIndependent Microsoft advisory helping enterprises extract full value from SQL Server Software Assurance through AHB activation, unlimited virtualisation, licence mobility, and EA renewal negotiation. Fixed-fee engagement models.