SQL Server Enterprise 2019 not core 21 up to

Question

Currently, I am using Windows Server 2016 and SQL Server Enterprise 2019, but the SQL system only utilizes 20 cores, even though I have allocated 60 cores to the server.

I have tried the following commands:

EXEC sp_configure 'affinity mask', 0;

EXEC sp_configure 'affinity64 mask', 0;

RECONFIGURE;

I have also checked whether the operating system detects the cores and reviewed the NUMA configuration, which shows that NUMA nodes from 3 onward are offline.

How can I bring the offline NUMA nodes online?

Answer 1

SQL Server 2019 (15.x) Enterprise (Core License) will support more than 20 cores per SQL Server Instance.

You can check your installed Edition with the following

SELECT SERVERPROPERTY('Edition')

Note that without Core-based licensing you would be limited to 20 cores per SQL Server Instance.

Enterprise edition with Server + Client Access License (CAL) licensing is limited to 20 cores per SQL Server instance. (This licensing isn't available for new agreements.) There are no limits under the Core-based Server Licensing model.

https://learn.microsoft.com/en-us/sql/sql-server/compute-capacity-limits-by-edition-of-sql-server?view=sql-server-ver16

Please consult with your licensing team to verify whether you have the correct licensing but you may have accidently installed the incorrect software edition. If you have Core-based licensing then you can follow the supported upgrade paths or perform a new install.

Supported Upgrade Paths

https://learn.microsoft.com/en-us/sql/database-engine/install-windows/supported-version-and-edition-upgrades-2019?view=sql-server-ver16#-edition-upgrade