none
sql server license RRS feed

  • Question

  • Hi,

    I got the below message 

    SQL Server detected 1 sockets with 4 cores per socket and 8 logical processors per socket, 8 total logical processors; using 8 logical processors based on SQL Server licensing. This is an informational message; no user action is required.

    So What is my license requirement based on the above text 

    Thanks

    Thursday, July 18, 2019 1:35 PM

Answers

  • yes, that is correct

    Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

    • Marked as answer by supportsib Friday, July 19, 2019 6:18 AM
    Thursday, July 18, 2019 2:08 PM

All replies

  • Thursday, July 18, 2019 1:38 PM
    Moderator
  • Hi

    Well it depends on how you want to license the server. If your are using standard edition then it can be licensed per CAL (Client assess license) or CORE. SQL Enterprise can only be licensed per CORE.

    Best option is understand your requirement and speak to the regional MS license team.

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

    Regards


     

    Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

    Thursday, July 18, 2019 1:42 PM
  • Hi,

    I want to go for core licensing , My question is  From that message how many core license i have to request 

    8 6 or 1 

    Thanks

    Thursday, July 18, 2019 2:01 PM
  • As per the message, the Server has 1 cpu with 4 core and Hyper threaded (No:Socket X Physical CPU X HT)=8

    Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

    Thursday, July 18, 2019 2:05 PM
  • HI,

    Thanks for the reply . So I have to request for 4 cores ? 

    Thanks

    Thursday, July 18, 2019 2:07 PM
  • yes, that is correct

    Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker

    • Marked as answer by supportsib Friday, July 19, 2019 6:18 AM
    Thursday, July 18, 2019 2:08 PM
  • Hi,

    This is i have taken from another sql server 

    SQL Server detected 2 sockets with 1 cores per socket and 1 logical processors per socket, 2 total logical processors; using 2 logical processors based on SQL Server licensing. This is an informational message; no user action is required.

    As per microsoft minmum license is 4 core , so what does it mean by above 

    is it licensed based on core  or is it server +cal license 

    How can i know from the sql server  about  licensing scheme 

    Thanks

    Thursday, July 25, 2019 6:08 AM
  • Hello,

    This is a community forum for technical questions & issues.

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

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

    See also eBook "SQL Server 2017 Licensing Guide"
    https://download.microsoft.com/download/B/C/0/BC0B2EA7-D99D-42FB-9439-2C56880CAFF4/SQL_Server_2017_Licensing_Datasheet.pdf


    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Thursday, July 25, 2019 6:36 AM
    Moderator
  • Hi,

    My  question , How can I see the current license from sql server ? 

    From sql server , is  there a way to check the current licensing scheme 

    Hope you understand 

    Thanks

    Thursday, July 25, 2019 7:03 AM
  • My  question , How can I see the current license from sql server ? 

    From sql server , is  there a way to check the current licensing scheme 

    No. The license is a piece of paper (well, probably a PDF these days) that you got from Microsoft or the re-seller you bought the license from.

    I would guess the message you found in the errorlog is an informational message that you can check against your license agreements to make sure that you are not violating them.


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

    Thursday, July 25, 2019 8:26 AM
    Moderator