Hi All,
Good Day !!!!! :smile:
We know M_CS_TABLES, M_TABLES to monitor about HANA RAM memory consumption by table wise.
But We can't find the information such as How much HANA Memory occupied by BW objects - Info Objects, DSO, Info cube, PSA, Change log.
This blog helps to identify HANA memory consumption by BW objects - Info Objects, DSO, Info cube, PSA, Change log.
1. Open the attached SQL document - HANA_MEMORY_CONSUMPTION_BY_BW_OBJECTS.sql
2. In the SQL statement, One small change has to be done. Replace String - SAPSID with your BW SCHEMA in all the places.
Example:
If your BW Schema is SAPBW1,
When "SCHEMA_NAME" = 'SAPSID' --> When "SCHEMA_NAME" = 'SAPBW1'
from "SAPSID"."RSTSODS" --> from "SAPBW1"."RSTSODS"
3. Execute the SQL statement and User Defined Function - HANA_MEMORY_CONSUMPTION_BY_BW_OBJECTS will be created on User Schema.
4. Call UDF Function and It will show HANA Memory occupied by BW objects - Info Objects, DSO, Info cube, PSA, Change log
Select * from "<User_Schema>"."HANA_MEMORY_CONSUMPTION_BY_BW_OBJECTS" ()
It will help us to monitor HANA Memory occupied by all BW objects and to take decisions like PSA_Cleanup and Changlog_Cleanup.
The SQL further can be enhanced like calculating
1. ADSO Memory consumption,
2. Info Objects Memory Consumption by types Master Data, Text, Hierarchy
Regards,
Muthuram
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
9 | |
8 | |
7 | |
7 | |
5 | |
4 | |
4 | |
4 | |
3 | |
3 |