Avatar of Jody Davis
Jody DavisFlag for United States of America asked on

Help understanding SQL Server 2016 pricing

We need to purchase a license for SQL Server 2016 Standard edition to be installed on a new VM running on Vmware 6.5.

The pricing model is a little confusing as it is per core, but will be on a esxi vmware host - but i assume it will be looked at for the number of cores i assign it within vSphere.

Please assist in understanding the true cost (server license or server license plus CAL?) of creating a new VM with that version, one SQL instance with multiple databases.

Thanks!
DatabasesMicrosoft SQL ServerVMwareVirtualizationSQL

Avatar of undefined
Last Comment
Jody Davis

8/22/2022 - Mon
Pavel Celba

You may purchase either the Core licenses for all the cores assigned to the VM or 1 Server license + CALs for all users/devices accessing the server.

This document explains it in more details: https://www.itprotoday.com/business-resources/overview-sql-server-2016-licensing
Scott Pletcher

Talk to a knowledgeable vendor.  SQL Server pricing is too complex now to try to wing it on your own, even with Google's "help".

Andrei Fomitchev

1. Developer (it matches Enterprise for non-production) or Express editions are free. - No need to buy a license for development or test.
2. Express edition is free for production, but if has limited functionality. It is good to start production use and complete initial load. Later you can upgrade it to Standard.
3. On the moment license real cores or virtual cores is almost the same.
4. Licensing virtual cores is good if you need less cores than your host has.
5. Licensing physical cores allows you to run several VMs on the same host.
6. To be able to move VM to another host you need SA. SA allows you version upgrade as well (like from SQL Server 2012 to SQL Server 2014).

For production it is better "Per core" - unlimited users/devices.
For test/development use (1).
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
ASKER
Jody Davis

So,

1. One vCPU equals one core license. Would make sense to use this with my 2016 SQL Server VMs.

2. From that website - A minimum of four core licenses is required for each physical processor on the server - so even if i only wanna use 2vCPUs for a single 2016 SQL server - does this mean i need to buy four core licenses to cover that single VM as it sits on a physical Esxi host?

3. If, like nearly all enterprise IT depts, i use DRS to loadbalance our VMs in a cluster (which is normal) - would i technically have to license the number of physical Esxi hosts as well - in that VM cluster - as the SQL Server will migrate around as cluster resource usage always changes?

4. Is Software Assurance required in a virtual environment to cover migrating around Esxi hosts in a cluster?

Thanks all !
ASKER
Jody Davis

Can i please get an answer to my questions?
Scott Pletcher

Again, talk to a knowledgeable vendor, even MS itself if you need to.  SQL Server pricing is too complex now to try to wing it on your own, even with Google's "help" / EE expertise.

Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER CERTIFIED SOLUTION
Pavel Celba

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Jody Davis

Thanks guys