1

SQL Server 2017 Express Edition only recognizes one CPU in AUTO when four are assigned. I can reassign the affinity so that it recognizes the rest, but the affinity type changes to MANUAL and it does not dynamically distribute the processes, but only does so in one. My SQL server is on Linux 20.04.

I tried to replicate it in a virtual machine but when I see which ones it assigns by AUTO, all of them are reflected, not just one.

Doug Deden
2,17110 silver badges14 bronze badges
asked Dec 14, 2023 at 18:52

1 Answer 1

2

Express edition only supports the lesser of 1 socket or 4 cores. You didn't post the VM configuration but I'd venture a guess it's setup at 4 socket/4 cores instead of 1 socket 4 cores.

answered Dec 14, 2023 at 19:11
4
  • No, the server is configured as 4 socket, 4 cores and the vm is 1 socket, 4 cores, Commented Dec 14, 2023 at 19:21
  • If the VM was configured for 1 socket and 4 cores then it'd use 1 socket up to 4 cores. That's the Express edition limitations. Commented Dec 14, 2023 at 19:57
  • Exactly, you said it, 4 cores but the server only takes 1 Commented Dec 14, 2023 at 20:54
  • 1
    Then you'll need to post the sys.configurations output, startup errorlog, and sys.dm_os_schedulers output Commented Dec 15, 2023 at 16:29

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.