SQL Licensing

I have 5 ESXi hosts & all the 5 ESXi hosts will form a single VMware cluster.
I believe the SQL licenses is based on the physical core CPUs.

So in this case if I form a single VMware Cluster & if I want my SQL servers to be part of only 2 hosts still do I need to have license for all the 5 ESXi hosts.
I want my SQL servers to be available in only 2 hosts. But all the 5 ESXI severs form a single VMware cluster.
How should i license it. Should i consider license for 2 hosts or I need to consider for 5 hosts.
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.

Kanti PrasadCommented:

 The licenses are given on total  users that connect to the DB and the other one is Core based. So if you know the correct count of users then you can go for User based or else Core would be ideal.

This thread has similar, discussion which can be of some help.

SrikantRajeevAuthor Commented:
I am targeting not on the no of users but on cores.
So for my above scenario for how many servers should we consider the licensing.
Andreas PeetzCommented:
Licensing MS SQL on vSphere is a complex topic, and the answer to your question depends on a lot of factors. In general you should discuss this with your Microsoft distributor or sales contact.

Relevant information is here:
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Andrew Hancock (VMware vExpert / EE MVE^2)VMware and Virtualization ConsultantCommented:
All hosts need licenses! look at the 90 days rules in License Mobility.

Unless you can prove, that you will only "lock down your VMs to two hosts", using DRS rules.

The current Microsoft SQL Guides are here

Microsoft SQL Server 2014 Licensing Guide

pay particular attention to what Microsoft calls License Mobility

Licensing Microsoft server products for use in virtual environments
Magnus AnderssonSolutions & Consulting ArchitectCommented:
use DRS must rules for VM-Host placement. That should do the job for you.

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
SrikantRajeevAuthor Commented:
SrikantRajeevAuthor Commented:
SrikantRajeevAuthor Commented:
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
Microsoft SQL Server 2008

From novice to tech pro — start learning today.