-
Title
Slow performance on FMS adding database agents and generating support bundles takes a long time due to ASP objects -
Description
Database agents cannot be added to a FMS and support bundle 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
1. Take a backup of the FMS Repository database
2. Delete the non current ASP configuration from the FMS repository using the following SQL
delete from persistable_config_model where user_created = 1 and version_id not in (select version_id from current_version);delete from pcm_encoded_data where version_id not in (select version_id from current_version);Note: The information in the script(s) provided is known to work successfully; however, they have not been officially tested by our Quality Control. If any of these instructions are changed and/or incorrectly used, intentionally or unintentionally, this solution becomes unsupported by our Support and Development. Support and Development recommend always making a backup of the current database prior to execution of any script(s) that may modify it.
STATUS
Enhancement Request FGLCM-63 and has been logged to purge the persistable 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