SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,221 questions
SQL Server Enterprise 2019 not core 21 up to
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(307.2, 61%, 39%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ENN%3C/text%3E%3C/svg%3E)
Nguyen ngoc giang
0
Reputation points
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?
{count} votes
-
Erland Sommarskog 114.6K Reputation points MVP2024-12-26T09:29:49.33+00:00 Have you checked the SQL Server errorlog? In the beginning of the log (like the first 20 lines or so), there should be message like this:
SQL Server detected 1 sockets with 12 cores per socket and 24 logical processors per socket, 24 total logical processors; using 24 logical processors based on SQL Server licensing. This is an informational message; no user action is required.
(This is from my desktop at home, running Developer Edition.)
Sign in to comment
Sign in to answer