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.