locked
How to identify the level of core licensing of a particular installed SQL Server Enterprise Edition? RRS feed

  • Question

  • How to identify the level of core licensing of a particular installed SQL Server Enterprise Edition?

    I couldn’t figure out how identify the level of core licensing of a particular installed SQL Server Enterprise Edition.

    For example, in the screenshot below, how about the level of core licensing of the installed SQL Server Enterprise? Is it 1 core or 2 cores?


    jamal

    Wednesday, January 29, 2020 12:28 AM

Answers

All replies

  • Hi jamal,

    It depends on the SQL server license that you buy. You can check the information from SQL server error log.

    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. 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. 

    According to your screenshot, it seems your SQL server is Enterprise Evaluation edition. This is not Enterprise edition. Evaluation edition of SQL Server is free for 180 days and it is equivalent to SQL Server Enterprise Version. If the validity of Evaluation period i.e. 180 days will exceed then SQL Server will shut down and will not come online. Please using select @@version to check your SQL server edition. 

    The 4 cores from your task manager is your server( your machine) has 4 cores, not your SQL server.

    Best regards,
    Cathy 


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Wednesday, January 29, 2020 2:03 AM
  • In addition

    https://www.microsoft.com/en-us/licensing/product-licensing/sql-server?activetab=sql-server-pivot%3aprimaryr2


    Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/

    MS SQL optimization: MS SQL Development and Optimization
    MS SQL Consulting: Large scale of database and data cleansing
    Remote DBA Services: Improves MS SQL Database Performance
    SQL Server Integration Services: Business Intelligence

    Wednesday, January 29, 2020 5:17 AM
  • Hi jamal,

    Any update? If the reply could help you, please mark the useful reply as answer. This can be beneficial to other community members reading the thread.
    In addition, if you have another questions, please feel free to ask.
    Thanks for your contribution.

    Best regards,
    Cathy 

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Thursday, January 30, 2020 8:59 AM
  • I have never got an answer to my question.

    I wanted to know the number of licensed cores for the SQL installed in the machine. The “select @@version” doesn’t bring this information


    jamal

    Thursday, January 30, 2020 7:29 PM
  • SQL Server does not store any information on the number of CPUs licensed, only that you have the "CPU licensed version".  You would need to look at your licensing paperwork.

    Thursday, January 30, 2020 9:07 PM
    Answerer
  • Hi  jamal,

    >>I wanted to know the number of licensed cores for the SQL installed in the machine. The “select @@version” doesn’t bring this information

    I suggest you check my reply again. It seems you misunderstood my thoughts. I suggest you use select @@version to check your SQL server edition. Because you said that your SQL server is Enterprise edition, but according to your screenshot, your SQL server is Enterprise Evaluation edition. This is only check your SQL server edition, not to check the number of licensed cores for SQL server.

    For your issue, as I mentioned above,  the number of licensed cores depends on the SQL server license that you buy. 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.  

    Best regard,
    Cathy 

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Friday, January 31, 2020 1:49 AM
  • Hi Cathy,

    Thank you for the input.

    The main issue here is to find out if there is a tool\command that identifies the number of licensed cores for the installed SQL.

    How about the cores when it comes to the evaluation edition? Does it take the full resources available in the machine?

    Best

    Jamal


    jamal


    Friday, January 31, 2020 7:17 PM
  • No, there is nothing in SQL Server which tracks or monitors the licensing of the SQL Server.  SQL Server licensing is 100% "honor system".   There is nothing in SQL Server or on the server itself which will tell you how many CPUs are printed on the piece of paper you received when you purchased your license.  As a result, there is nothing in SQL Server which enforces the CPU count you purchased.

    The evaluation edition is equivalent to the "Enterprise" edition.

    Please see:

    https://docs.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-version-15?view=sql-server-ver15


    Friday, January 31, 2020 7:55 PM
    Answerer
  • Thanks Phillips. It is a bit clearer now

    Best

    Jamal


    jamal

    Saturday, February 1, 2020 8:24 AM