• Status: Solved
  • Priority: High
  • Security: Public
  • Views: 87
  • Last Modified:

SQL license

I have read so many internet posting regarding the SQL VM licensing. I have no way of understanding them. Hope someone would explain the way the license works.
What is the best license option in the following scenario?
We have 10 ESXI hosts in the cluster, five ESXi hosts have 26 Core (2CPU) and five have 44(2x22).
We have 10 SQL servers at each with 4 core. They all VMs and requires vMotion.
0
sara2000
Asked:
sara2000
  • 3
  • 2
3 Solutions
 
Aaron TomoskySD-WAN SimplifiedCommented:
1. use core licenses for the sql VMs. 2x (2 core) licenses per vm. The esxi hosts don't matter. $7k per vm one time (2x $3500) no SA, or $10k with SA
2. use server licenses, and user licenses, this usually only makes sense under 20 users when comparing to the minimum 4 core vm.
0
 
sara2000Author Commented:
Thank you for the information.
"you can only move the SQL VM between hosts once every 90 days unless you maintained active SA on those Core licenses".
If I understood correctly SA covers CAL, am I correct?
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
If you license the cores on the ESXI hosts then you can install as many SQL Server instances as you want. You can even elect one or two ESXI hosts to be dedicated for SQL Server so you just need to license those cores.
It's just a matter of making the necessary calculations. Example:
10 x SQL Server in 4 cores VM vs 1 x ESXI host with 44 cores
0
Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

 
sara2000Author Commented:
Vitor,
If you suggest 10x 4 core sql.
How do we archive mobility and CAL. We are not going to restrict to particular ESXI host. That is they are free to move on all.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
If you're going to license by core then you can't license it by CAL, i.e. or you pay by CPU or by device.
Restriction by ESXI host is a strategic decision and can help your company to save lots of money if you have plenty of SQL Server instances to install. But that's what I'm used to work with (hundreds of SQL Server instances) and I understand that if you're working with few SQL Server instances then this option might not be attractive at all.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
Recommendation to close this question by accepting the above comments as solution.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now