Question:
Staging and Migrations are taking an excedingly long time to finish.
Answer:
The recommended maintenance is to truncate the staging tables on a weekly basis.
Before running the below query, ensure that all staging and migrations have completed.
truncate TABLE CLUSTER_METRICS_STAGING ;
truncate TABLE CLUSTER_STAGING ;
truncate TABLE CPU_METRICS_STAGING ;
truncate TABLE DISK_METRICS_STAGING ;
truncate TABLE DIVERSE_DATA_STAGING ;
truncate TABLE DIVERSE_METRIC_STAGING ;
truncate TABLE GENERIC_DEVICE_METRICS_STAGING ;
truncate TABLE GROUP_CONFIG_STAGING ;
truncate TABLE NETWORK_METRICS_STAGING ;
truncate TABLE PROCESS_METRICS_STAGING ;
truncate TABLE RESOURCE_POOL_METRICS_STAGING ;
truncate TABLE RESOURCE_POOL_STAGING ;
truncate TABLE SAP_CONFIG_STAGING ;
truncate TABLE SAP_DAILY_MEMORY_STAGING ;
truncate TABLE SAP_DAILY_STAGING ;
truncate TABLE SAP_DAILY_SUMMARY_STAGING ;
truncate TABLE SAP_HOURLY_TASK_STAGING ;
truncate TABLE SAP_HOURLY_TIME_STAGING ;
truncate TABLE SAP_RFC_METRICS_STAGING ;
truncate TABLE SERVER_METRICS_STAGING ;
truncate TABLE SERVER_STAGING ;
truncate TABLE SERVER_VIRTUAL_STAGING ;
truncate TABLE SUBSYSTEM_METRICS_STAGING ;
truncate TABLE WORKLOAD_LOG_STAGING ;
truncate TABLE WORK_TRANS_METRICS_STAGING ;