SQL 2016 Server cpu core

[hoiyi88]

Hi ,

I've assign a 12 vCore for sql 2016 standard edition, but only SQL Server task manager can see 4 core have high usage when SQL Server have heavy workload.

Any advise?

Thanks.

[daphnissov]

Is it one socket and 12 cores or 12 sockets and one core? Show a screenshot of the VM's configuration if unsure.

[hoiyi88]

Attached the screen dump for the CPU assignment.

Thanks.

[daphnissov · Accepted solution]

There's your problem. You've configured 12 sockets. SQL 2016 standard only allows use of the lesser of 4 sockets or 24 cores. You'll need to configure your VM in such a way that you stay below those maximums

[hoiyi88]

I've 2 physical CPU for the host, so I can config mix 8 vCore for SQL Server?

Thanks.

[daphnissov]

I'm not sure what you're asking. How many physical CPU sockets are in your ESXi host are largely irrelevant to how you configure cores vs sockets on this VM.