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

May 15, 2018 719 views
Miscellaneous Ubuntu 16.04 Initial 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!

Be the first one to answer this question.

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