Agent Manager (FglAM) CPU spikes to nearly 100% from SQL Server agents (4295822)

The CPU on an Foglight Agent Manager (FglAM) increases to 99% and 100%.

When only the SQL Server agents are deactivated on the FglAM, the CPU for all of the other remaining agents total 25%-30%.

WORKAROUND

Change the SSL connection parameter in the Agent Properties from "Optional" to either "Off" or "Mandatory" for all of the SQL Server agents depending on the SSL requirements of the SQL Server instance.

1. Navigate to Administration | Agents | Agent Status
2. Select the checkbox one or more of the database agents that require a change of the SSL connection type and version settings.
3. Click the Edit Properties button
4. (for single agents only) Click the link to Modify Properties for this agent only
5. Scroll down to the Monitored Connection profile area and set the SSL Connection to Mandatory
6. Set Enforce SSL Version to TLSv1.2
   
7. Click the Save button
8. Deactivate and activate the database agent

Please note that ALL of the SQL Server agents which require a settings change for the SSL connection should be updated. The presence of even one agent with a misconfigured SSL connection could caused the FglAM CPU to spike to 100%. 

The following script can be used to list the current SSL Connection and TLS settings for all of the SQL Server agents installed on the FMS.

def out = new StringBuilder();
def agentService = server.get("AgentService"); def configService = server.get("ConfigService"); def agents = agentService.findByAdapterAndType("FglAM", "DB_SQL_Server"); for (agent in agents) {
   def primaryASP = configService.getAgentInstancePrimaryAsp(agent.getAgentNamespace(), agent.getTypeId(), agent.getId());
   if (primaryASP) {
      out.append(String.format("%s, %s: SSL=%s\n", agent.getRemoteClientId(), agent.getName(), primaryASP.getString("monSSLConnection")));
      out.append(String.format("%s, %s: TLS=%s\n", agent.getRemoteClientId(), agent.getName(), primaryASP.getString("monEnforceSSLVersion")));
   }
}

return out.toString();