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.
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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?
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
IT Pros Agree: AI and Machine Learning Key

We’d all like to think our company’s data is well protected, but when you ask IT professionals they admit the data probably is not as safe as it could be.

sara2000Author Commented:
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.
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.
Vitor MontalvãoMSSQL Senior EngineerCommented:
Recommendation to close this question by accepting the above comments as solution.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.