Forum Discussion
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.
- LicensingConcierge1Microsoft
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
- LicensingConcierge1Microsoftto add, Partners can log into Partner Center to find the current SQL Server 2022 Licensing guide.
Regards,
Microsoft CSP Licensing Concierge - VaibhavDeepani1Copper Contributor
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?
- LicensingConcierge1Microsoft
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