-
Title
Which SQL Server or Oracle Server topology objects are part of the object cleanup? -
Description
Which SQL Server Foglight topology objects are part of the object cleanup? -
Cause
Core has provided a built-in mechanism to remove stale topology objects. These topology objects (or collections) are be logically removed from monitoring (such as databases, files, tablespace, etc.). -
Resolution
In the 5.7.5.7 SQL Server cartridge the developers defined these monitored objects can be removed from monitoring so their topology will be deleted, for the most part they used the default Foglight cleanup duration.- DBSS_Availability_Groups
- DBSS_Availability_Groups_Listeners
- DBSS_Availability_Groups_Replicas
- DBSS_Availability_Groups_Databases
- DBSS_File_Group
- DBSS_File SQL Server File topology instances
- DBSS_Logical_Disks SQL Server Logical Disks topology instances
- DBSS_Agent_Job_List
- DBSS_Database
- DBSS_Plan_Cache
The Oracle objects that can be added for purging are:
- Oracle Agent Model
- Oracle Datafile
- Oracle Datafile IO Activity
- Oracle Invalid Objects
- Oracle Rac Clusters Data
- Oracle Tablespace
-
Additional Information
If the registry value for "server.topology.objectExpiryDays" is not configured for an object type, it will try to use its parent's, if still not found, it will search according to the type hierarchy until TopologyObject type, and will use the first value it find except the TopologyObject's (which is called the default value of this registry variable).
For example, the DBSS_Replication_Agent's type extension hierarchy is:
DBSS_Replication_Agent->DBSS_Replication_Alarm_Object->DBSS_Topology_Alarm_Object->DBSS_Topology_Object->TopologyObject
If the object type does not have the "server.topology.objectExpiryDays" configured for itself or any of their parent objects in the hierarchy, the expected behaviour will be for it to remain in the topology forever unless it is manually removed or the object added to the variable to take part of object cleanup tasks.
Please check reference: How to Add Topology Objects to Stale Object Cleanup Dashboard SOL206989