Online Tutorials & Training Materials | STechies.com
Register Login

Good retention time for statistics server histories

Romil Tripathi || 26 Mar 2015 5:02 pm || 1

Hello Experts,

What is a good retention time for statistics server histories?

Thanks in advance.


Comments

  • 15 Apr 2015 2:37 pm 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 )