About Sz_An

Sz_An

The compositelimit out of memory trace In SAP HANA there is a way to limit the memory that can be allocated by a single SQL statement (1999997 - FAQ: SAP HANA Memory): Starting with SAP HANA 1.0 SPS 08: As a prerequisite you need to have the state...

Sz_An

Hello Luis, If you can see in the trace that your composite limit is = 30GB, it means that your statement_memory_limit is set to 30 GB. In some rare cases, you will see that your statement_memory_limit is higher than what is shown in the trace as c...

Sz_An

Hello Mithran,Yes, the CPU information there is in %.High CPU and high workload situations can be best analyzed by runtime dumps. They show how many threads you have, and what they are doing.1813020 - How to generate a runtime dump on SAP HANA2498739...

Sz_An

Hello,You can find the grant statement syntax here:https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.05/en-US/20f674e1751910148a8b990d33efbdc5.htmlBest Regards,Anna

Sz_An

Hello Hozefa,9.2 mil records in the output seems way too much. If I could have a guess this is the cause of the memory issue. I would recommend to use further filtering in order to reduce the result set. I had to let you know this information regardl...

Sz_An

Hello,You can get useful information about the startup timestamps of the different hosts with the help of statement "HANA_Startup_StartupTimes". The statement can be found in the attachments of SAP Note 1969700 - SQL Statement Collection for SAP HANA...

User Statistics

User Activity

How to identify the SQL statement text from compositelimit oom trace

Re: How to identify the SQL statement text from compositelimit oom trace

Re: HANA CPU and Threads

Re: SAP HANA Privileges

Re: SAP HANA Calculation view: Error:Memory allocation

Re: How to check HDB Shutdown and Startup History in SAP HANA