Licensing is really complex, but as long as you know these seven rules, you can go a long way:
- If you query it, you have to license it.
- “It” means the Windows environment – all of the processor cores that Windows sees. (Things get a little weirder under virtualization.)
- Offloading a backup or a DBCC is considered querying.
- If you license it, and you pay Software Assurance, you get exactly one free standby server of equivalent size. (Standby means you’re not querying it.)
- Standard Edition costs about $2k USD per core, but caps out at 16 cores and 128GB RAM (for SQL 2014, or 64GB for 2012).
- Enterprise Edition costs about $7k USD per core.
- Software Assurance is an additional annual fee that gives you free upgrades as long as you keep paying for it.
Then to learn more, get the 2014 Licensing Guide on the right side of the licensing portal.
Got a question not answered by these rules? Head over to the Microsoft licensing chat.
Want help? Talk to Brent for free.
If you need to reduce your Enterprise Edition licensing exposure, we can help.
Our 3-day SQL Critical Care® is a quick, easy process that identifies your top bottlenecks and gives you the easiest, cheapest way past them. We can help you reduce the number of CPU cores you need to run your workloads.