Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

100% Synch with HANA MEMORY Utilized Tables Info


I logged into BW on HANA System. in DB02 - When i see overview. The Memory used shows 618 GB out of 974 allocated Size.

I downloaded the HANA SQL Scripts from SAP Note : 0001969700 - SQL statement collection for SAP HANA

& ran SQL script - "HANA_Tables_LargestTables"  [changed 600 Number of records to be returned by the query]



01. I asked for 600 Records - but it returns only 250 Records

02. The Total Size of only 439GB - where DB02 shows 618GB Memory Utilized < The last Row size in MEM_GB is almost "ZERO">

Help Required from Experts


1) As already the lowest 250th table size is almost ZERO & The 250 Tables Memory Utilization is 439GB - But DB02 shows 618 GB.....Where & How 618-439 = 179 GB is missing.

2) it is 1 TB applicance and 974 GB allocated , at hostlevel if we see freespace it shows only 1GB out of 1TB.  The misssing 179GB is uptake memory-but loaded with Tables

How i can get 618 Utilized Memory Objects info.

Please Help


Former Member
Not what you were looking for? View more on this topic or Ask a question