How to increase Foglight topology instance limits? (4311089)

Foglight Management Server (FMS) log has entries complaining of topology limit reached:

The configured limit of 50000 instances of type HostProcess has been reached

The configured limit of 50000 instances of type DB2_Database_Partition_Table has been reached.

Foglight has a default limit of 50000 topology instances per object type.

Ideally, if the FMS has reached a topology limit, it would be best to first delete any stale objects of that type.
Reference the groovy script from KB 62094.  One then runs this script passing arguments for the topology type & age in days (ie. 2 where any object two days old is deleted).

Use the dashboard to manage the stale object deletion:

1. Go to Administration | Management Server | Servers | Object Cleanup | Object Management (lower right hand corner)
2. Search for the affected Topology Type
3. Click Auto-delete | Set the preferred Stale Object Removal
4. To delete immediately, apply a filter on the right hand side, select the objects, and delete.

To change the topology limit, we suggest setting a higher value for just the Topology Type of interest.

1. Administration | Rules and Notifications | Manage Registry Variables
2. Search and Click  foglight.limit.instances  View & Edit Details.
3. In the lower Registry Values section, click the green Add icon.
   • Search for your Toplogy Type
   • Click your Topology Type
   • Select All Objects (rather than a specific object listed for your selected topo type)
   • Enter a Static Value (e.g. 100000)
   • Finish

Foglight Management server should not need to be restarted for this change.

When changing the topology limit for a specific object type and searching for a topology type name it may not appear on the list as it may have a different display name.

For example, the alarm message could be "The configured limit of 50000 instances of type DBSS_Wait_Statistics has been reached.", but on the list to select a topology type the type name will appear as "SQL Server Wait Statistics" instead of "DBSS_Wait_Statistics".

To confirm the topology type display name:

1. From the Foglight web console, go to: Administration | Tooling | Script Console
2. On the query input field, copy the topology type name as it appears in the alarm. E.g: "DBSS_Wait_Statistics".
3. Click on "Do Query".
4. The display name will be shown in the "List Instances" drop down menu.