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

May 15, 2018 357 views
Initial Server Setup Miscellaneous Ubuntu 16.04

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.