Symptom
ABAP DBACOCKPIT Alert monitor a/o the SQL Server instance SQL error log indicates following warning message:
----
Warning: Enterprise Server/CAL license used for this instance. This edition limits SQL Engine CPU utilization to 20 physical
|yyyy/mm/dd hh:mm:ss| Server | cores, or 40 logical cores with Hyper-threading enabled.
|yyyy/mm/dd hh:mm:ss| Server | SQL Server detected 3 sockets with 8 cores per socket and 8 logical processors per socket, 24 total logical processors
|yyyy/mm/dd hh:mm:ss| Server |; using 20 logical processors based on SQL Server licensing.
----
In this case, the warning message means the system server gets 24 CPUs, however, the system is only using up to 20 CPUs.
Read more...
Environment
Microsoft SQL Server 2019 and SQL Server 2022 "Enterprise Edition"
Keywords
. , KBA , BC-DB-MSS , SQL Server in SAP NetWeaver Products , BC-DB-MSS-SYS , Database Interface/DBMS for MSS , BW-SYS-DB-MSS , BW on Microsoft SQL Server , BC-DB-MSS-INS , SQL Server Installation for SAP NetWeaver Products , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview