SQL Server Software Assurance (SA) costs 30% of the SQL Server licence price annually. For an 8-core Enterprise Edition server, that is approximately £17,520 per year. In 40–70% of enterprises we audit, that SA is delivering minimal or zero commercial value.
Yet the decision to carry SA or remove it from renewal is not straightforward. Some SA benefits — specifically license mobility for Azure migration and unlimited virtualisation rights — deliver exceptional value in the right circumstances. Other SA benefits (e-learning, support escalation) are seldom used. This guide walks through the SQL Server SA value calculation: which benefits matter, when to keep SA, and when to remove it from your EA at renewal to reduce costs.
What Software Assurance Includes
SQL Server Software Assurance provides eight primary benefits. Not all apply to every deployment:
| SA Benefit | Value Category | Annual Cost Equivalent | Typical Usage |
|---|---|---|---|
| License Mobility (Azure/AWS migration) | High Value | £6,200–11,600 | 40% of enterprises with SA |
| Unlimited Virtualisation (Enterprise only) | High Value | £4,800–8,200 | 35% of enterprises with Enterprise Edition |
| Failover Rights (passive HA servers) | Medium Value | £2,400–4,100 | 15% of enterprises |
| Server/CAL Hybrid Rights | Medium Value | £1,200–2,050 | 8% of enterprises |
| Home Use Rights (developer licenses) | Low Value | £520–1,040 | 5% of enterprises |
| Technical Support Escalation | Low Value | £260–520 | 3% of enterprises |
| SQL Server Upgrade Rights | Low Value | £390–780 | 2% of enterprises |
| E-Learning & Training | Rarely Used | £130–260 | <1% of enterprises |
High-Value Benefits: Keep SA If You Use These
License Mobility for Azure Migration
License Mobility allows you to migrate SQL Server licences from on-premises to Microsoft Azure and pay a significantly reduced Azure compute rate (typically 55–80% less than standard Azure VM rates). This is the highest-value SA benefit for enterprises considering or planning cloud migration.
For a typical 8-core SQL Server Enterprise Edition instance migrating to Azure:
- Standard Azure compute cost: £18,200–22,400 annually
- With License Mobility: £4,100–8,900 annually
- Annual saving from License Mobility: £14,100–13,500
- SA cost: £17,520 annually
- Net ROI: Break-even within 15 months, then positive cash flow
If you have a credible timeline for cloud migration (within 24 months), License Mobility SA often pays for itself. If migration is vague or 3+ years away, SA may not be justified.
Unlimited Virtualisation (Enterprise Edition Only)
SQL Server Enterprise Edition SA includes unlimited virtualisation rights: once your host is licensed for Enterprise with SA, all virtual machines on that host can run SQL Server Enterprise with no additional licensing. This eliminates the complexity and cost of per-VM licensing or vMotion cluster coverage workarounds.
For a typical vMotion cluster with 4 hosts and 15 VMs:
- Without SA: 4 hosts × 16-core Enterprise licences (£29,750 per 2-core pack) = £238,000 initial + vMotion cluster coverage complexity
- With SA: Same £238,000 + £70,080 annual SA (4 hosts × £17,520)
- Benefit: Eliminates £12,000–18,000 vMotion coverage workaround cost and simplifies governance
- ROI Timeline: 4–6 years payback
Unlimited virtualisation SA is only justified if you have dynamic virtual machine environments requiring frequent vMotion or failover. If your SQL Server VMs are static, SA may not be economical.
Medium-Value Benefits: Evaluate Your Specific Use Case
Failover Rights (Passive HA Servers)
SA includes the right to run a passive failover copy of SQL Server for disaster recovery at no additional licence cost. Without SA, failover rights require separate licensing for the passive copy (typically 75% of active-server cost). For an Always On Availability Group with primary and secondary, failover rights can save £4,800–8,200 annually depending on edition and core count.
However, this benefit is only valuable if:
- Your failover environment is licensed and in use (many enterprises have unlicensed failover copies in violation of their EA)
- You are not planning to decommission the failover copy within the SA term
- The failover server is genuinely passive (not read-only, not used for reporting)
Low-Value Benefits: Why Most Enterprises Should Remove SA
The remaining SA benefits — Home Use Rights, Technical Support Escalation, Upgrade Rights, and E-Learning — collectively deliver minimal commercial value to most enterprises. Yet enterprises carry them anyway, at a cost of £3,200–4,800 per instance annually.
Home Use Rights: Allows developers to install SQL Server on personal computers. Most enterprises have no use case for this. The benefit can be replicated by licensing fewer Developer Edition instances (which are free).
Technical Support Escalation: Provides faster support response times and direct escalation to Microsoft engineering. Most enterprises never use this benefit; they manage SQL Server support through standard vendor contracts or internal SLA models. Microsoft support escalation is rarely the bottleneck in incident response.
Upgrade Rights: Allows you to upgrade to the next version of SQL Server with no additional licensing cost. In practice, most enterprises follow Microsoft's mainstream support cycle (5 years) and upgrade before support ends, so the right to "upgrade at any time" provides no economic value.
Calculate the annual SA cost per instance, then ask: "Which of these 8 benefits are we actually using?" In 60% of cases, the answer is "None" or "Only one — and we can get it elsewhere." That is your removal opportunity.
When to Remove SA from Your EA at Renewal
Scenario 1: End-of-Life SQL Server Instances
If you have SQL Server 2012, 2014, or 2016 instances still in production (past Microsoft mainstream support), the only SA benefit you are receiving is licensing simplicity — and even that is arguable. Removing SA from end-of-life instances is a direct cost reduction with minimal downside.
Strategy: Audit your SQL Server instance portfolio by version and support status. Remove SA from all mainstream support-ended versions. Typical savings: £15,600–31,200 per end-of-life instance.
Scenario 2: Development and Test Servers
Development and test SQL Server instances typically do not justify SA cost. These servers are temporary, frequently rebuilt, and do not require failover rights or virtualisation benefits. If SA cost is £17,520 annually for a Dev server that will be decommissioned in 18 months, you are overpaying.
Exception: If your dev servers are in Azure and you are using License Mobility, keep SA on those instances.
Scenario 3: Small Instances Under 8 Cores
On very small SQL Server instances (4–6 cores), SA cost is still significant (£8,760–13,140 annually), but the absolute value of virtualisation or failover benefits is small. These instances may not justify SA from a pure ROI perspective.
Scenario 4: No Migration or HA Planning
If your SQL Server instances are projected to remain on-premises and static for the next 3+ years, and you do not have failover/HA requirements, there may be no SA benefit to claim. This is your strongest removal case.
Using SA Removal as Renewal Leverage
At EA renewal, you can use SA removal strategically in negotiations:
- Proposal 1: "We are removing SA from 40 instances to reduce cost. In exchange, we are consolidating to SQL Server Enterprise with enhanced support on the remaining instances."
- Proposal 2: "We will retain SA on 8 instances for License Mobility support and remove it from the remaining 32. This reduces our total SQL Server cost by 28% and justifies a 3-year renewal commitment."
- Proposal 3: "We are evaluating a 50% reduction in SQL Server per-core licences by consolidating instances. In that consolidation scenario, SA becomes economically justified on the consolidated instances."
Each of these positions demonstrates active management of SQL Server licensing and creates a basis for negotiating price improvements elsewhere in your EA.
The SA ROI Decision Framework
To decide whether to keep SA on a specific instance, calculate the annual value of each benefit:
- License Mobility benefit: Only if migration within 24 months — otherwise £0
- Unlimited Virtualisation benefit: Only if using vMotion cluster with Enterprise Edition — otherwise £0
- Failover Rights benefit: If you have a licensed, passive failover copy — otherwise £0
- All other benefits: Realistically, £0 for most enterprises
If the sum of those benefits is less than the annual SA cost, remove SA at renewal. If the benefits exceed SA cost, keep SA and factor the net savings into your renewal negotiation.
If you keep SA for failover rights but do not actually license the failover copy, Microsoft auditors will flag this in an audit. Do not claim SA benefits you cannot prove and defend.
Key Takeaways
- SA is high-cost: 30% of licence price annually — £17,520 per Enterprise 8-core instance
- Only 2 benefits have consistent value: License Mobility (for migration) and Unlimited Virtualisation (for dynamic Enterprise environments)
- 40–70% of enterprises overpay: Carrying SA with no claimed benefits is a direct cost reduction opportunity at renewal
- End-of-life instances: Immediate removal candidates — no benefits, just cost
- Use removal as negotiation leverage: "We are rationalizing SA to reduce cost" is a strong position in renewal talks