question

a3pl-4697 avatar image
0 Votes"
a3pl-4697 asked Cathyji-msft commented

SQL 2019 Core license on Hyper-V cluster

Scenario:
I want to make a Windows Hyper-V 2 node cluster and run a 8 core VM with SQL Standard core on it.
There will be only one VM with SQL, no passive one.
Only in case of update of host operating system or failure of one of the nodes, machine with SQL should be moved for downtime to the other node.
What license should I buy ?
Only 8 cores or i have to get it with SA ? Buying SA only for updating host operating system ? Rather weird but possible.

I haven't found answer for that question anywhere. All scenarios are talking about active/passive SQL cluster.

Anyone has such configuration ?

sql-server-generalwindows-server-clustering
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @a3pl-4697,

Any update for this thread? Did the reply could help you? If the response helped, do "Accept Answer". If it is not, please let us know.

0 Votes 0 ·
LeonLaude avatar image
0 Votes"
LeonLaude answered a3pl-4697 commented

Hi @a3pl-4697,

Please note that these are technical forums, and is not meant for providing legal advice on licensing. licensing questions are best asked directly to a trained Microsoft licensing specialist.

You can contact Microsoft directly and discuss your licensing needs - www.microsoft.com/licensing

Some general information:

  • Each host needs to be licensed.

  • A minimum of 8 core licenses is required for each physical processor and a minimum of 16 core licenses is required for each server.

  • Core licenses are sold in packs of two (2).

  • Standard Edition provides rights for up to 2 Operating System Environments or Windows Servers containers with Hyper-V isolation when all physical cores in the server are licensed. For each additional 1 or 2 VMs, all the physical cores in the server must be licensed again.

  • Datacenter Edition provides rights for unlimited Operating System Environments or Windows Servers containers with Hyper-V isolation when all physical cores in the server are licensed.

You'll also find some licensing information here:

If the reply was helpful please don't forget to upvote and/or accept as answer, thank you!


Best regards,
Leon


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

My question was about SQL Server license for database running on lonely VM (no passive) in Hyper-V cluster.
Windows licensing is simple enough.

0 Votes 0 ·
TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered TomPhillips-1744 commented

You are not using a "cluster", you are simply using a "virtual machine". The licensing guide addresses your questions.

https://www.microsoft.com/en-us/sql-server/sql-server-2019-pricing

· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

So, in that case, is that important, in terms of licensing, on which physical host on Hyper-V cluster am I running VM with SQL server ?
I had 3 answers from various sources, more or less official.
1. I have to buy 8 core license for VM and it is enough.
2. I have to buy 8 core license for VM with SA to get rights to move running VM between physical nodes of Hyper-V cluster more often than 90 days.
3. I have to buy 2 x 8 core license for each node on which I can run VM with SQL.

Once more, I do not want to run any OSE with passive SQL.
VM will be running all the time on one of the Hyper-V cluster nodes and i want to move that running VM only to second node in case of maintance or failure, no load balancing.

0 Votes 0 ·

For detailed information about the license issue, please call 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist. For international customers, please use the https://www.microsoft.com/en-us/licensing/worldwide to find contact information in your locations.

0 Votes 0 ·
Cathyji-msft avatar image
0 Votes"
Cathyji-msft answered Cathyji-msft edited

Hi @a3pl-4697,

There will be only one VM with SQL, no passive one.

If you do not have passive node, you need to buy 2 x 8 core license for each node on which you can run VM with SQL.

If the node2 is the passive node, and you can choose the second option that you mentioned.

But this is technical forum, for SQL server license question, I still suggest that you can consult professionals in this area. please call 1-800-426-9400, Monday through Friday, 6:00 A.M. to 6:00 P.M. (Pacific Time) to speak directly to a Microsoft licensing specialist. Or you can go to Volume Licensing Service Center support. Please choose region/language and choose to call or have web. People there will help you more effectively.


If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".



5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.