Skip to Content
Former Member
Dec 15, 2012 at 10:32 AM

SAP HANA - Memory Usage / Activating the Trace


Hello together,

I have two questions about the Memory Usage in SAP HANA, as it is described on Page 13-14 in SAP HANA Developer's Guide for the SQL Function Fuzzy Search - SAP HANA Appliance Software SPS 04.

1) When I fire off the following SQL-Statement in the HANA-Cloud (30 days trial), I get no result:

I would like to check to additional memory consumption by adding a fuzzy-search-index in several columns.

SELECT * FROM sys.m_heap_memory WHERE category LIKE '%FuzzySearch%'

-> Why do I get no result?

2) Do I have to activate the TRACE in SAP HANA Studio, to check the Memory Usage by fireing off the above named SQL-Statement?

Thank you very much for helping.

Best Regards,