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
  • It looks like it is related to this issue mssqltips.com/sqlservertip/4801/…
    – Greg
    Commented Dec 10, 2018 at 14:15
  • If you're using VMware, you'll need to change Cores per socket to 8 so that you have 4 sockets. This post outlines how to accomplish this. Commented Dec 10, 2018 at 22:09

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
    Commented Dec 10, 2018 at 14:19
  • Yes that should work, up to 24 cores obvs. Otherwise upgrade to Enterprise Edition Commented Dec 10, 2018 at 17:04

Your Answer

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

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