I have a situation whereas the CA Configuration Automation (CCA) Agent is spawning addition process when it starts to collect information on the targeted SQL DB server. During this process the CCA Agent processes consumed so much of the system resources that it effective brought the production SQL DB Server processes to a halt. I have seen this issue only once before, and that was on an HP-UX DB system. The one thing the both the Windows SQL and the HP-UX DB Servers had in common was that they both were associated with a LARGE amount of storage devices (30 or more).
I talked with a colleague who experienced something similar with a different application. It seems that upon a request to gather information on the targeted server the agent starts to scan the system. However, when it gets to the storage devices, which are many, it seems to start new scans on additional devices before it completes the previous scans initiated. Since each scan uses systems resources (CPU, memory), each new scan may get slower. And since it's using additional resources, other processes on the system start slowing up also. If this process (adding additional scans) persists, all resources are used up by the CCA Agent processes and the all other process are brought to a halt.
If this is indeed the issue my question is: Has anyone else experienced this issue? And if so, how did you resolve and/or work around it? Is there a way to configure and/or customize a particular parameter that governs this behavior?
Any help would be greatly appreciated.
Retrieving data ...