3202692 - How to set Memory Limit for SQL Statements

You can set a statement memory limit to prevent single statements from consuming too much memory.

By default, there is no limit set on statement memory usage, but if a limit is applied, statement executions that require more memory will be aborted when they reach the limit.

To apply these settings you must have the system privilege INIFILE ADMIN.

For these options, enable_tracking and memory_tracking must first be enabled in the global.ini file. Additionally, resource_tracking must be enabled in this file if you wish to apply different settings for individual users.

• SAP HANA 2.0

HANA , Memory, staement_meomry_limit, SQL, optimization, WORKLOAD, TOTAL_STATEMENT_MEMORY_LIMIT , KBA , HAN-DB-PERF , SAP HANA Database Performance , HAN-DB , SAP HANA Database , How To