Skip to Content

HANA memory - Limit per user maximum

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 03, 2017 at 05:09 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 05, 2017 at 05:10 PM

    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 ?

    Add comment
    10|10000 characters needed characters exceeded