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

4

Standard Edition is limited to 4 sockets or 24 cores

  • 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 '18 at 14:19
  • Yes that should work, up to 24 cores obvs. Otherwise upgrade to Enterprise Edition – Andrew Brennan Dec 10 '18 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.