HANA Statement CPU Limit

[Former Member]

Hello,

We currently utilize the following parameters:

ALTER SYSTEM ALTER CONFIGURATION ('global.ini','SYSTEM') SET ('memorymanager', 'statement_memory_limit_threshold') = 'xx' with reconfigure;

ALTER SYSTEM ALTER CONFIGURATION ('global.ini','SYSTEM') SET ('memorymanager', 'statement_memory_limit') = 'xxx' with reconfigure;

It works great with users ( reporting ) eating up a lot of memory resources. It kills their connection.

What I would like to know...Are there any settings that would limit CPU usage ? We noticed a few Tableau dashboard reports eating up CPU resources and freezing the SAP application.

Cheers! and thank you in advance.

/gxo13

[former_member183326]

If it is freezing I would recommend you take some runtime dumps and a kernel profiler during the freeze to see whats happening.

[nicholas_chang]

Hi,

you may also want to research more on parameter max_sql_executors, max_concurrency , max_concurrency_hint, default_statement_concurrency_limit , num_cores  to control the total of cpu consumption by sqlexecutor, job worker and its parallelism.

You need a throughout testing before put this parameter into production to avoid undesired effect.

Thanks,

Nicholas Chang

[lbreddemann]

Nope, there is nothing similar for CPU usage per session/statement/user (so far).

Check Controlling CPU Consumption - SAP HANA Administration Guide - SAP Library to see what options are available.

[mcalucin]

Hi Lars,

Anything new with regards to limiting CPU usage per user?

Thanks.

Regards,

Mel Calucin

[lbreddemann]

Yes, there is. You want to check out the workload management features in HANA 2.