Article Number | 000033835 |
Applies To | RSA Product Set: Archer RSA Version/Condition: All Platform: Windows |
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. |