|Applies To||RSA Product Set: RSA Archer|
RSA Version/Condition: 6.x
|Issue||Observations show the Windows Server CPU cores were only being used at 15% to 30% and the Archer data feeds and calculations were slow due to Windows CPU cores being parked. This was specific to the SQL database server for Archer.|
|Cause||Cores in parked status are supposed to help save energy consumption by having very minimal workloads while other cores take care of the heavy workloads. The result is that you save energy, but the small few cores with heavy workloads cause slow performance. |
This issue manifested itself in SQL server but could occur with Windows Server 2008 specifically and higher versions of Windows if configured for core parking/reduced power management. This can also happen with Virtual Machines if so configured.
|Resolution||Adjust Window Server's power plan in order to have the CPU cores perform above a low percentage. This allows for higher and optimized CPU usage throughout the cores. As a result, increased performance with data feeds and calculations. |
Microsoft has provided the following details regarding core parking. Windows Server 2012, by default, disables the core parking for Intel processors. Other processors such as AMD, does not. Windows Server 2008 does not.