Data / Table | Description |
Partition tables | These data tables are used to store the performance metric raw data for APM Insight Monitors for every minute. |
Stray tables | These data tables are not in use currently. They might be left stray, with no lookup entries. ( Left stray from upgrades to builds before 15280 ). |
Retention period | This specifies the APM Insight Raw Data Retention Period and can be found in Admin -> Performance Polling -> APM Insight -> Raw Data Retention Period |
Traces | The traces found in APM Insight -> Traces Tab are stored in the custom path specified at <APM_Home>/working/apminsight/conf/apminsight.properties -> apminsight.tracesdir (or) <APM_Home>/working/apminsight/traces |
Current Partition Tables | These data tables are used to store the current week's raw performance data. |
Older Partition Tables | These data tables have performance metric raw data older than the retention period. |
- Open Command prompt or Terminal and Navigate to <APPMANAGER_HOME>/bin
- Execute the below mentioned command:
WindowsAPMInsightDataCleanup.bat <OPTIONS>Linuxsh APMInsightDataCleanup.sh <OPTIONS>
Options | Description | Usage | |
olderdata | It does clean up of stray tables , partition tables and trace files - which are older than retention period. | sh APMInsightDataCleanup.sh olderdata | APMInsightDataCleanup.bat olderdata |
stray | It is used to delete only the stray tables (which are no longer used.) | sh APMInsightDataCleanup.sh stray | APMInsightDataCleanup.bat stray |
olderpartitions | It is used to delete only the partition tables which are older than retention period. | sh APMInsightDataCleanup.sh olderpartitions | APMInsightDataCleanup.bat olderpartitions |
oldertraces | It used to delete only the trace files older than retention period. | sh APMInsightDataCleanup.sh oldertraces | APMInsightDataCleanup.bat oldertraces |
full | It will delete all partition tables, trace files ( current and older than retention period. ) | sh APMInsightDataCleanup.sh full | APMInsightDataCleanup.bat full |