|Applies To||RSA Product Set: Archer|
RSA Version/Condition: All
|Issue||When using SQL Server Standard Edition or SQL Server Express Edition, you may see a high utilization of 1-4 cores while the rest of the cores on the system are idle and not used. This leads to a significant performance bottleneck on the SQL Server.|
|Cause||As per Microsoft, the licensing of SQL Server Standard Edition limits the maximum utilized sockets to 4 and also limits the maximum utilized cores to 24. If each socket has only 1 core, this license limits SQL Server Standard Edition to using a maximum of 4 cores.|
|Resolution||If the SQL Server is deployed as a VM, this can be resolved by increasing the number of cores assigned to each socket.|
If SQL Server is deployed on dedicated hardware (non-VM) then the license of SQL Server will have to be upgraded to make use of the available hardware.