-
Title
Slow performance on FMS or generating support bundles takes a long time due to ASP objects -
Description
Foglight Management Server (FMS) performance is very slow or support bundles takes a long time (24 hours) to generate.
-
Cause
There was a very large number of ASP (Agent Status Property) configuration objects indicated in the Diagnostic Snapshot file (found in the FMS support bundle)
| pcm_encoded_data | 2,161,425 | 16,436,183,040 | || persistable_config_model | 2,161,418 | 139,804,672 | 152,469,504 |Extra Info at :DDD MMM DD HH:MM:SS CST YYYY---- default configs ----==== PersistableConfigModel ====-- namespace: HostAgentstype: WindowsEventLogMonitorAgent>>>>>>>>>>>>>>>-- Finished at: DDD MMM DD HH:MM:SS CST YYYY --
The following SQL SELECT statements run against the FMS repository can also provide helpful information
select count(*) from persistable_config_model where user_created = 1 and version_id not in (select version_id from current_version);select count(*) from pcm_encoded_data where version_id not in (select version_id from current_version); -
Resolution
WORKAROUND
Please refer to KB 331817 for a workaround for this issue.
STATUS
Enhancement Request FGLCM-63 and has been logged to purge the ASP tables regularly in the Foglight Management Server. This has been included in the 5.9.8 and higher releases of the FMS.
Enhancement Request FGL-20607 has been logged to clean up the secondary ASPs that are not being used by agents to be included in a future release of the Foglight Management Server.
-
Defect ID
FGL-20607