Good retention time for statistics server histories
Updated May 18, 2018
What is a good retention time for statistics server histories?
Thanks in advance.
15 Apr 2015 2:37 pm Shalesh Singh Visen Best Answer
Experience has shown that a retention time of 6 weeks (42 days) is a good compromise between size and analysis capabilities. Having 6 weeks of history available it is always possible to compare current issues with a time of the same load one month back (e.g. month's end closing).
Standalone statistics server:The standalone statistics server mainly used a retention time of 30 days. Rather than adjusting the retention time, it is recommended to switch to the embedded statistics server.
Embedded statistics server:With the embedded statistics server the retention time for most of the history tables is already 42 days. Nevertheless there are still a few history tables with a rather small default retention time. Check ID 750 ("Stat. server tables with retention < 42 days") of SQL: "HANA_Configuration_MiniChecks" (SAP Note 1969700) reports tables where the retention time may be increased to 42 days.
For the following collectors a reduced retention time is useful or acceptable:
Collector_Global_Dec_Extractor_Status (ID 5008)
Collector_Global_Internal_Events (ID 5026)
Collector_Host_CS_Unloads (ID 5035)
For all others you can adjust the retention time to 42 days with the following command:
UPDATE _SYS_STATISTICS.STATISTICS_SCHEDULE SET RETENTION_DAYS_CURRENT = 42 WHERE ID NOT IN ( 5008, 5026, 5035 )