This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](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(214.4, 24%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ET%3C/text%3E%3C/svg%3E)
Hello SQL Server community,
I’ve previously tried changing my current SQL server license from core based to CAL but it’s not working, and I know that it’s not working because the current core based license is for 4 cores while the VM has 8 and SQL is still unable to access the remaining 4 cores after the EditionUpgrade I ran with the new product key.
The process runs normally and all checks are in the green.
The SQL Agent service account has SA access to the instance.
My account is an Administrator on the box and an SA on the instance.
The setup summary.txt and Details.txt files have nothing that stands out.
Current SQL Edition: SQL Server 2019 standard edition core based licensing
I’d appreciate any assistance regarding this matter.
Thanks!
![](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(67.2, 1%, 16%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETP%3C/text%3E%3C/svg%3E)
The licensing is not tracked or enforced by the SQL Server.
Standard edition is limited to:
Limited to lesser of 4 sockets or 24 cores
If you want to use 8 CPUs, you need to setup your VM correctly with the number of NUMA cpus. See:
https://learn.microsoft.com/en-us/previous-versions/windows/it-pro/windows-server-2012-R2-and-2012/dn282282(v=ws.11)
Hello Tom,
Thank you for your answer, but it doesn’t address my issue, the SQL server license isn’t changing from core based to CAL, the error log shows that SQL is using 4 out of the available 8 cores due to the current SQL license configuration, and when I try to configure SQL’s NUMA node access it complains about the license.
I’ve used both the UI and CMD to perform the License change, both came back with passed checks but the license change didn’t take effect.
I’d say that my first priority is to figure out the actual license change and then worry about the NUMA node configuration.
If you have a different idea I’m open to hearing back from you.
Thank you!!
Again, this is not due to the licensing of the SQL Server. It is due to you running Standard Edition SQL Server. Standard edition cannot use >4 sockets.
You need to configure your VM correctly for SQL Server to see all 8 CPUs.
What does SELECT @@VERSION return?
Thank you!!!! You just made my day! You are 100% correct, i failed to realize the specificity of Your previous comment, the VM does in fact have 8 sockets and 1 core per socket, that’s why no matter what I tried SQL Standard couldn’t access the other 4 cores. I’ll be doing 2 things, first I’ll reconfigure the VM to have 4 sockets with 2 cores in each, and second I’ll be saluting you.
You should configure the sockets/cores to match the host server if possible. It will be better for the VM.