000038343 - SQL Server and Windows Server using Parked CPU Cores impacts RSA Archer performance

Document created by RSA Customer Support Employee on Jan 17, 2020
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000038343
Applies ToRSA Product Set: RSA Archer
RSA Version/Condition: 6.x
IssueObservations 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.
CauseCores 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.
ResolutionAdjust 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.