Forum Discussion

VaibhavDeepani1's avatar
VaibhavDeepani1
Copper Contributor
Jun 23, 2023

SQL Server Standard - 24 Core Limit - Licensing

Hi Team,

Hope you are doing well.

I do not want to put up a duplicate question, so please excuse my ignorance, and if this question is already answered, would request you to direct me to the correct link.

With SQL Server Standard (Core or Server-CAL model), there is a limit on compute capacity and maximum number of cores should be 24 cores.

Would request your help to understand what impact will it have on licensing i.e. do we need to assign such server (assuming running 32 cores) the Enterprise Core edition license? Or do we need to stack SQL Server Standard Core licenses?

Appreciate any inputs here.

  • Hi VaibhavDeepani1 

     

    To clarify, you need to know how to license a server that has 32 cores, correct?  Is this for an EA agreement?

     

    If so, there are no limits under the Core-based Server Licensing model. Once you know the number of cores, you would purchase that number of licenses, dividing by 2, since core licenses are purchased in 2-packs. Therefore, 32 divided by 2 = 16 core licenses.

     

    (the Enterprise edition w/ Server + CAL based licensing w/ Server + CAL based licensing is limited to 20 cores per SQL Server instance).

     

    If this (or someone else's) reply answers your question, please Accept as the solution to help the other members find it more quickly. Otherwise, please let me know if you need further assistance on this topic.


    Regards,

    Microsoft CSP Licensing Concierge

     

    • LicensingConcierge1's avatar
      LicensingConcierge1
      Icon for Microsoft rankMicrosoft
      to add, Partners can log into Partner Center to find the current SQL Server 2022 Licensing guide.

      Regards,

      Microsoft CSP Licensing Concierge
    • VaibhavDeepani1's avatar
      VaibhavDeepani1
      Copper Contributor

      LicensingConcierge1 

      Thank you so much for your reply.

       

      Please refer this link once Compute capacity limits by edition of SQL Server - SQL Server | Microsoft Learn

      This says SQL Server Standard (both for Core and Server CAL) edition has a Maximum compute capacity for a single instance which is 

      Limited to lesser of 4 sockets or 24 cores

       

      Here is the screenshot from MSFT SQL Server guide:

       

       

      Now does this means we need to assign Enterprise Edition (Core) to the server if that is running with 32 cores capacity?

      • LicensingConcierge1's avatar
        LicensingConcierge1
        Icon for Microsoft rankMicrosoft

        VaibhavDeepani1 

         

         Please carefully review my reply above where I stated that for Enterprise Server + CAL there is a max of 20:

         

         

        I believe my initial response answers your question where I stated and provided documentation of how to calculate using the core licensing model 

         

        That means you should can use SQL Server 2022 Enterprise or SQL Server 2022 Standard and use the core licensing model calculation that I provided above:

         

         

         

        If you have other BizApps questions, please let me know.

         

        If this (or someone else's) reply answers your question, please Accept as the solution to help the other members find it more quickly. 


        Regards,

        Microsoft CSP Licensing Concierge

         

         

Resources