Other Engine Components (misc) of Index Server

[former_member182925]

When I run the "Component memory usage" System Information view (from the HANA Administration console) I see that most of the memory used by our HANA server is used by "Other Engine Components (misc.)" by the Index Server. It's even much more than our loaded column store tables and our machine has been idle for the past 6 hours.

This raises some questions that I hope somebody can answer for me:

- What are those other engine components?

- Should I be worried about the amount of memory consumed by these components?

- Can I reduce the footprint of these components?

[Former Member · Accepted solution]

Hi, this query will show you all the components of "other engine components (Misc.)"

SELECT host,

       port,

       'Other Engine Components (misc.)' AS COMPONENT,

       sum(EXCLUSIVE_SIZE_IN_USE) AS USED_MEMORY_SIZE,

       CATEGORY

  FROM SYS.M_HEAP_MEMORY_

where CATEGORY not in ('Pool/malloc/libhdbrskernel.so',

                        'StackAllocator',

                        'Pool/RowEngine/SQLPlan',

                        'Pool/RowEngine/Transaction',

                        'Pool/MergeMonitor',

                        'Pool/Statistics',

                        'Pool/malloc/libhdbcscommon.so',

                        'Pool/itab',

                        'Pool/malloc/libhdbbasement.so',

                        'Pool/malloc/libhdbcs.so',

                        'VirtualAlloc')

   and CATEGORY not like '%MemoryMapLevel2Blocks'

   and CATEGORY not like 'Pool/RowEngine%'

   and CATEGORY not like 'Pool/PersistenceManager%'

   and CATEGORY not like 'Pool/AttributeEngine%'

group by HOST,

          PORT,

          CATEGORY

order by USED_MEMORY_SIZE desc;

And see note 1840954.

[former_member182925 · Accepted solution]

Perfect, that was what I was looking for!