question

Brian-6907 avatar image
0 Votes"
Brian-6907 asked Criszhan-msft commented

How can I enable the SQL Server to see and use the other CPUs?


ENVIRONMENT
Standard E48as_v4 (48 vcpus, 384 GiB memory)
Hyperthreading DISABLED
SQL 2016 Enterprise



PROBLEM
My SQL server license limits me to 20 CPUs. I do not know how to get my SQL server to see the other 4 CPUs.

The following query was one of the methods used to validate the server uses 20 of the 24 CPUs. (Hyperthreading is disabled)
SELECT scheduler_id,
cpu_id,
STATUS,
is_online
FROM sys.dm_os_schedulers
where STATUS = 'VISIBLE ONLINE'

QUESTION:
How can I enable the SQL Server to see and use the other 4 CPUs?

Other Information:
-I use volume licensing
-Microsoft SQL Server 2016 (SP2-CU16) (KB5000645) - 13.0.5882.1 (X64) Jan 25 2021 21:40:32 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows Server 2019 Datacenter 10.0 <X64> (Build 17763: ) (Hypervisor)
-From the log File: SQL Server detected 1 sockets with 24 cores per socket and 24 logical processors per socket, 24 total logical processors; using 20 logical processors based on SQL Server licensing. This is an informational message; no user action is required.

sql-server-general
· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello,

Unfortunately the people who set up this server used a server+CAL license when it should be core-based. I am trying to find out if there is a way to change the licensing to core-based. Thank you.

0 Votes 0 ·
TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered Brian-6907 commented

You have apparently configured all your CPUs to a single socket. That is not optimal or recommended.

I suggest you read this "3.5 Virtual Machine CPU Configuration":

https://www.vmware.com/content/dam/digitalmarketing/vmware/en/pdf/solutions/sql-server-on-vmware-best-practices-guide.pdf

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Thank you for your comment.

0 Votes 0 ·
Criszhan-msft avatar image
0 Votes"
Criszhan-msft answered Criszhan-msft commented

Hi,

Enterprise Edition with Server + Client Access License (CAL) licensing is limited to 20 cores per SQL Server instance.

I am trying to find out if there is a way to change the licensing to core-based.

For question regarding pricing / licensing please contact a Microsoft sales partner or licensing expert. Call (1-800-426-9400), Monday through Friday, 6:00 AM to 6:00 PM PST to speak directly to Microsoft licensing specialist.Or you can go to Volume Licensing Service Center support. Please choose region/language and choose to call or have web.


· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi @Brian-6907,

we have not get a reply from you. Did any answers could help you? If there have any answers helped you, please do "Accept Answer". If not, please let us know. By doing so, it will benefit for community members who have this similar issue. Your contribution is highly appreciated. Thank you!

0 Votes 0 ·