Something about licensing SQL Server

  • Hi all,

    a question about licensing.

    If i understood licensing of SQL Server Standard for core, if i have a server with 2 processor with 4 core for processor, i must license SQL Server for 8 cores.

    But the question is: if i buy license for 4 core and install SQL Server on this server with 8 core, simply SQL Server does not use every core or i'm not legally licensed??

    I MUST buy license for every core of my server??

    Thank you very much

    Paolo

  • Check with Microsoft on that. They have phone and online support for licensing questions. Answers you get from them are official. Anything you get from us is just our own opinions, and should be confirmed with Microsoft anyway.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • paolobianchi (5/31/2016)


    But the question is: if i buy license for 4 core and install SQL Server on this server with 8 core, simply SQL Server does not use every core or i'm not legally licensed??

    The latter

    I MUST buy license for every core of my server??

    If the core is visible, it must be licensed (hence you can't use processor affinity to get around the licensing requirements)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass
  • Thanks to all.

    I found on Microsoft the answer, i MUST licence all core

    •To license a physical server, you must license all the cores in the server with a minimum of 4 core licenses required for each physical processor in the server.

    Thank you

    Paolo

  • paolobianchi (6/1/2016)


    Thanks to all.

    I found on Microsoft the answer, i MUST licence all core

    •To license a physical server, you must license all the cores in the server with a minimum of 4 core licenses required for each physical processor in the server.

    Thank you

    Paolo

    What's the link for that?

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • https://www.microsoft.com/en/server-cloud/products/sql-server/purchasing.aspx and click the "Read the SQL Server 2016 Licensing datasheet" link. (or http://download.microsoft.com/download/F/D/5/FD5E5C28-6973-4273-8737-D69AA3BEA243/SQL_Server_2016_Licensing_Datasheet_EN_US.pdf, though no guarantees it won't move.)

    The 2012 and 2014 licensing guides had similar wording, though they're no longer available from the MS website.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply