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 correc...
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
Microsoft
Microsoft
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
- LicensingConcierge1VaibhavDeepani1
If you have additional SQL Server questions, it might be best that you post to their community instead of BizApps - https://techcommunity.microsoft.com/t5/sql-server/ct-p/SQL-Server
Regards,
Microsoft CSP Licensing ConciergeNo, actually the point is - assuming such server (with 32 cores) is running SQL Server Standard. In that case, can i assign SQL Server Standard 32 cores license to such server? because, based on the screenshot, 24 core is max compute capacity that SQL Server Standard Core can support.
So my question is - do we need to assign SQL Server Enterprise Core or assigning the SQL Server Standard core is fine?
- Hi Vaibhav,
I am not a Microsoft certified partner nor employee. But I have come across such use case, so I would like to share my experience with you.
https://learn.microsoft.com/en-us/sql/sql-server/compute-capacity-limits-by-edition-of-sql-server?view=sql-server-ver16#:~:text=These%20limits%20apply,capacity%20limits%20allow.
Based off the documentation above, you may stack SQL Server Standard licenses in a single physical host. You mentioned you have a 32-core physical server to be installed with SQL Server Standard (ideally). In that case, you may purchase two SQL Server Standard (instance + CAL) licenses to overcome the 24 core max limit. With that, you will have 2 instances of SQL Server.
Hope that helps.
Regards,
Wong
