3721138 - EarlyWatch Alert reports “Number of collectors with retention times < 42 days” in SAP HANA environments

In SAP EarlyWatch Alert (EWA) the following warning appears:

Number of collectors with retention times < 42 days = 4

The customer verifies the SAP HANA configuration and executes:

SELECT s.ID,
       o.NAME AS OBJECT_NAME,
       s.RETENTION_DAYS_DEFAULT
FROM _SYS_STATISTICS.STATISTICS_SCHEDULE s
JOIN _SYS_STATISTICS.STATISTICS_OBJECTS o
  ON s.ID = o.ID
WHERE s.RETENTION_DAYS_DEFAULT < 42
ORDER BY s.RETENTION_DAYS_DEFAULT ASC;

The SQL query returns multiple statistics collectors with retention times below 42 days, which does not match the value reported in the EarlyWatch Alert.

Customer Interpretation

• SAP HANA monitoring misconfiguration
• Statistics server malfunction
• Assumption that disabling collector 5008 is required
  

SAP HANA DB Version 2.0

ewa report, collectors retention times, sap hana monitoring, statistics server, retention days, monitoring history data, workload history collectors, sap hana statistics schedule, earlywatch alert, monitoring data storage usage , KBA , HAN-DB-MON , SAP HANA Monitoring , Problem