SAP Community will be read-only this weekend (Saturday, August 31, through Sunday, September 1). Activities requiring log-in won't be possible. Learn more in this What's New post.
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...
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...
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...
Hello,You can find the grant statement syntax here:https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.05/en-US/20f674e1751910148a8b990d33efbdc5.htmlBest Regards,Anna
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...
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...