MSSQL 2017 Express on Ubuntu only uses 1 vCPU instead of 4 because vCPU's reported as sockets instead of cores.

Posted May 15, 2018 975 views
MiscellaneousUbuntu 16.04Initial Server Setup

We have installed MSSQL 2017 Express on Ubuntu and the CPU limits for this version are the Lesser of 1 Socket or 4 Cores. The vCPU’s are reported in Ubuntu as Sockets so 4 sockets instead of 4 cores, so MSSQL only picks up 1 Socket and can only process on 1 vCPU instead of 4. Is this correct behaviour? Is there a way to make it report differently or are we stuck with it working this way?

Thank you for the help!

Submit an answer

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!