Skip to Content
Former Member
Jan 30, 2014 at 09:37 AM

Ability to limit HANA resource usage for end users


A question regarding the possibities within HANA to limit the resource usage for (specific) end users.

A HANA platform (single node) is set-up in such a way that end users are allowed to create queries (via BI 4.x). However, several times already there was the situation where an end user created a query which consumed all resources of the HANA platform (for now, not focussing on training these end users, or making sure they create a decent query, etc). This resource consumption already lead to the unavailability of the platform, and even a direct restart of the HANA platform (unexpectedly initiated by HANA itself).

So, is it possible to limit the resource consumption for users (like preventing expensive statements)? Is there a particular setting in HANA to do this? Or is it just a matter of ‘educating’ end users?