HANA memory limit for SQL run

[former_member201054]

Hi Experts,

Which one will be considered by HANA for deciding the SQL memory limit in HANA 2.0 database for over consuming statements?

Statement_memory_limit parameter value

(or)

Defined memory limit value in a Workload class

Please answer.

Thanks in advance

[ghoshsayantan3]

Hi Daniel,

I have seen statement_memory_limit take on value of workload class in Hana 2.0 sps 05.So you can try using it,its effective for each individual statement under a user name for the workload class.

I hope this inputs help in your required scenario.

Regards

Sayantan