SQL LICENSE

Ahmed Maher Abdelsalam 21 Reputation points
2021-01-27T09:34:11.683+00:00

60923-screenshot-2021-01-26-151651.png

I have SQL server on VM and i need to calculate the number of core to determine the needed license,

Please check the attachment how can I determine the amount of cores which need to be licensed because its very confusing me

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,159 questions
{count} votes

3 answers

Sort by: Most helpful
  1. CathyJi-MSFT 22,331 Reputation points Microsoft Vendor
    2021-01-28T03:03:23.747+00:00

    Hi @Ahmed Maher Abdelsalam ,

    Server + CAL or Per Core are the software licensing options. It must be noted however that the Enterprise edition is only available under the Per Core model.

    If you choose Per Core licensing option, licenses must be assigned to all of the physical cores on the server, when running SQL Server in a physical environment. A minimum of four core licenses per physical processor are required, with licenses being sold in packs of two.

    For example, SQL Server has two processors, each with six cores:

    1.Ascertain how many cores there are per processor (keeping in mind the minimum requirement of four cores per processor)
    2.Count the total number of cores
    3.A total of twelve cores are present, therefore 6 SQL Server Per Core licenses (packs of 2) are required.

    From your screenshot, you have two processors, each with 15 cores. So the total of thirty are present, therefore 15 SQL Server Per Core licenses (packs of 2) are required.

    Please refer to the blog An Introduction to Microsoft SQL Server Licensing to better understanding this.

    If you have further license question, suggest you 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. 

    Best regards,
    Cathy


    If the response is helpful, please click "Accept Answer" and upvote it, thank you.

    1 person found this answer helpful.

  2. Olaf Helper 45,366 Reputation points
    2021-01-27T09:40:13.363+00:00

    Hello,

    On a VM you have to license all available cores, see https://download.microsoft.com/download/B/C/0/BC0B2EA7-D99D-42FB-9439-2C56880CAFF4/SQL_Server_2017_Licensing_Datasheet.pdf => page 2 => Licensing for virtualization and containers

    For further question regarding pricing / licensing please contact a Microsoft sales partner or licensing expert.

    Call (1-800-426-9400), Monday through Friday, 6:00 AM to 6:00 PM PST to speak directly to Microsoft licensing specialist.

    0 comments No comments

  3. Shashank Singh 6,251 Reputation points
    2021-01-27T12:06:03.383+00:00

    What is output of select @@version if this is enterprise edition you would have to license all 30 cores. If this is standard edition you can use lesser of 4 sockets or 24 cores. If for example you have 2 sockets and each socket has 15 core you use more than 15 cores for sql server. So think wisely.


Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.