Forum Discussion
VaibhavDeepani1
Jun 23, 2023Copper Contributor
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...
VaibhavDeepani1
Jun 24, 2023Copper Contributor
No, 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?
helpwong
Jun 28, 2023Copper Contributor
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
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