000033835 - SQL Server Standard Edition does not utilize all of the available CPU cores and RSA Archer performs poorly

Document created by RSA Customer Support Employee on Aug 23, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 3Show Document
  • View in full screen mode

Article Content

Article Number000033835
Applies ToRSA Product Set: Archer
RSA Version/Condition: All
Platform: Windows
IssueWhen 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.
User-added image
CauseAs 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.
ResolutionIf the SQL Server is deployed as a VM, this can be resolved by increasing the number of cores assigned to each socket.
User-added image

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.

Attachments

    Outcomes