Skip to Content
0

HANA memory - Limit per user maximum

Jun 02, 2017 at 05:39 PM

140

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Florian Pfeffer
Jun 03, 2017 at 05:09 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Gopikrishna Eriki Jun 05, 2017 at 05:10 PM
0

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 ?

Share
10 |10000 characters needed characters left characters exceeded