Link to home
Start Free TrialLog in
Avatar of Jody Davis
Jody DavisFlag for United States of America

asked on

How much is SQL Enterprise regarding physical/virtual CPU usage?

I want to do some work that states it needs SQL Enterprise. I would think either SQL2012 or SQL2016. The task is irrelevant. I know it is more expensive than SQL Standard. We use VMware on blade servers that have numerous physical Intel CPUs and of course have hyperthreading. I know MS changed their licensing not long ago.

Let's say (to keep numbers round) i want to assign 10vCPUs to this new SQL2012/2016 VM. If my blade server happens to have 20 physical sockets with hyperthreading enabled, how would MS charge me for that VM?  If - let's say just to make it easy - MS charged $100 per whatever Ent SQL metric they now use to charge for SQL - how much would that cost me?  These are notional amounts, but you understand what i'm asking. How much would this situation cost me with those make-believe numbers - so i can then take that process and apply it to my real-world hardware/software?

If you would be so kind, please try and provide the notional $$ amount and a link for actual info as well. This is a side-project and was hoping not to investigate too much - time wise :)
ASKER CERTIFIED SOLUTION
Avatar of Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)
Andrew Hancock (VMware vExpert PRO / EE Fellow/British Beekeeper)
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Above link from Andrew would be a good start for the Licensing guide..
Since you wanted to calculate the rough amount, sharing some unofficial license cost calculators..
Enterprise Edition
https://wintelguy.com/mssql-ent-licensing-calc.pl
Standard Edition
https://wintelguy.com/mssql-std-licensing-calc.pl

Another website, with SA costs included..
https://www.sqlgovernor.com/en/calculator/
Avatar of Member_2_231077
Member_2_231077

>If my blade server happens to have 20 physical sockets with hyperthreading enabled, how would MS charge me for that VM?

They would buy the server off you and sell it to a blade server manufacturer to clone it, Did you mean 20 cores?
Avatar of Jody Davis

ASKER

Using the SQL server pricing list for 2017 from the link you provided, Andrew - am i right in saying if i wanted to create a VMware VM and install SQL server 2017 and have 2-VMware vCPUs for the VM - the cost for that server for just SQL alone would be over $14k?
RRP is over $14k, you may get a discount. May be better to sort through your blades to see if you have a dual-core one and use that, at least you could turn hyper-threading on to get 4 virtual cores at the same price.
Thanks guys, more than i wanted to pay for. but this is what i needed to know.