Monitoring and Statistical Data memory usage

[kevin_joyner]

So there's a lovely query that shows HANA memory usaged by componet.

SELECT

        host,

        component,

        sum(used_memory_size) used_mem_size

FROM PUBLIC.M_SERVICE_COMPONENT_MEMORY

group by host,

        component

ORDER BY sum(used_memory_size) desc;

Results show I have quite a bit more being used by "Monitoring & Statistical Data" than I do the actual column store.

How do I clear/shrink these areas?

[lucas_oliveira · Accepted solution]

Hello Kevin,

I'd go with the HANA_Memory_TopConsumer* query available in SAP Note 1969700 instead.

The result will give you a hint on what to do next (column MEMORY_REDUCTION_APPROACHES).

Important to remind that some areas will grow and that's expected. More info on SAP Note 1999997.

BRs,

Lucas de Oliveira

[kevin_joyner · Accepted solution]

Actually I figured it out thanks to the memory view in the hana cockpit which pointed to statistics specifically and note 1929538 which helps with clearing the memory and setting a retention period.

[lucas_oliveira · Accepted solution]

If you're still using the standalone version of statistics server I advise you to migrate it to the embedded version. Far less headaches with the later one.