0

I have a situation where my SQL server is capped at a constant CPU usage rate (13%) and only four cores are being utilizedCPU.

There is no resource governors or anything like that in place.enter image description here

This runs on VMWare environment. SQL Server 2016 Windows 2016

cpu cap

enter image description here

2

1 Answer 1

4

Standard Edition is limited to 4 sockets or 24 cores

2
  • 5
    Perhaps the solution is to change the VMWare config so that it's not a 1-to-1 mapping between sockets and cores.
    – Dan Guzman
    Dec 10, 2018 at 14:19
  • Yes that should work, up to 24 cores obvs. Otherwise upgrade to Enterprise Edition Dec 10, 2018 at 17:04

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.