SQL Server Enterprise License

Hi,

I want to buy SQL Enterprise 2014 for windows server 2012R2 (4 servers working as cluster SQL). Each server has 64 core. What license I must buy?

Thanks
Math TecAsked:
Who is Participating?
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.

pcelbaCommented:
Well this depends on many factors...

The basic rule for Enterprise version is the licensing per CPU core where the number of clients is irrelevant. So you would need 64 x 4 licenses as the most expensive option.

But you have many more options, e.g. Do you plan to install the SQL Server on the hardware directly or in some virtual environment?

Do you plan to use all 4 servers for active data access or some of them are planned for mirroring, replication or high availability?
If some of your instances will be used as passive or redundant instances then there is a possibility to have just a half of licenses.

Everything is described in this document: http://download.microsoft.com/download/6/6/f/66ff3259-1466-4bba-a505-2e3da5b2b1fa/sql_server_2014_licensing_datasheet.pdf
Long version: http://go.microsoft.com/fwlink/?LinkId=230678

BTW,  I would recommend to skip SQL 2014 and focus on SQL 2016 or 2017 instead. It will have longer support and it will support more features than 2014 and the licensing is similar.

SQL 2016 licensing: https://download.microsoft.com/download/9/C/6/9C6EB70A-8D52-48F4-9F04-08970411B7A3/SQL_Server_2016_Licensing_Guide_EN_US.pdf

SQL 2017 licensing: http://download.microsoft.com/download/7/8/c/78cdf005-97c1-4129-926b-ce4a6fe92cf5/sql_server_2017_licensing_guide.pdf

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
Math TecAuthor Commented:
Thank you for your reply,

But you have many more options, e.g. Do you plan to install the SQL Server on the hardware directly or in some virtual environment?
install directly on the hardware

Do you plan to use all 4 servers for active data access or some of them are planned for mirroring, replication or high availability?
high availability

Thanks
pcelbaCommented:
OK, to use HA with one passive instance you don't need licenses for the passive instance. The active instance must be licensed with SA which is more expensive than w/o SA but still cheaper than licenses for all cores. HA with all instances active requires licenses for all cores.

Every dealer will give you free consultations for such a high performance 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
SQL

From novice to tech pro — start learning today.