HANA memory - Limit per user maximum

[gopibuz]

We have HANA Live queries, and SAP/BO Analysis For Office using these queries on HANA DB. We have a situation where one of the query consumed lot of resource and slowed the system and literally bring down the system.

Is there any way to LIMIT how much a USER can consume resource on HANA DB ?

Thanks

Gopikrishna Eriki

[gopibuz]

Thanks for the reply.

Setting this at individual user level is time consuming; is there a way we can set a limit of any USER ?

[pfefferf]

If you wanna limit the memory consumption of a user you can do this with following statement:

ALTER USER <user_name> SET PARAMETER STATEMENT MEMORY LIMIT = <gb>

Further detailed information can be found in the Troubleshooting Guide or in the Administration Guide.

Regards,
Florian