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

Jody Davis
Jody Davis used Ask the Experts™
on
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 :)
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
VMware and Virtualization Consultant
Fellow 2018
Expert of the Year 2017
Commented:
Enterprise Licensing is Per Core, in 2 Core Packs, and you can choose to license underlying hardware on hosts or the virtual machines.

https://www.microsoft.com/en-au/sql-server/sql-server-2017-pricing

(the above link, gives the actual license guides you need to follow)
Raja Jegan RSQL Server DBA & Architect, EE Solution Guide
Awarded 2009
Distinguished Expert 2018

Commented:
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/
Top Expert 2014

Commented:
>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?
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Jody DavisSystems Engineer

Author

Commented:
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?
Top Expert 2014

Commented:
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.
Jody DavisSystems Engineer

Author

Commented:
Thanks guys, more than i wanted to pay for. but this is what i needed to know.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial