Skip to Content
1
Former Member
Sep 25, 2014 at 12:42 PM

High DB Resident consumption + Unload table process from memory

115 Views


Hi SAP experts,

I need your great help!

We have implemented the HANA accelerators for all standard scenarios available and some custom programs, as well as the HANA Live package for critical areas (almost 200 tables replicated in real time). Now we are facing issues in HANA productive related to DB Resident consumption (see attached) and I have realized that indexserver logs has increased significantly.

My questions are:

1) How can I check which specific process is causing this issue? Reset Memory Statistics would be a good practice to release space?

2) I read that HANA has an automatic process to unload tables and release memory space. Does it work only for virtual memory? Besides this process is it a good practice to do the manual unload?

3) Is it possible find by period how many unloads tables were done automatically? I know the general query select * from "M_CS_UNLOADS" but it is not specified by period.

Sorry for many questions. I really appreciate your comments for these points.

Thanks in advance.

Best Regards,

Amanda

Attachments

Index_server.PNG (29.6 kB)