Restrict HANA Schema Size

[former_member674669]

Hello everyone,

Does anyone know of a way to restrict the size (memory allocation) of a specific schema within SAP HANA?

We are granting a set of users the rights to create within a schema, but need to limit the overall size of their tables.

Thanks a lot,

- Matt

[lbreddemann]

Nope, there is no such thing available.

SAP HANA doesn't support user based memory quota limitations.

Typically low level access and privilege to create objects is considered developer/DBA level, so the expectation would be that the users keep an eye on this themselves.

However, most likely the best way to approach this requirement on SAP HANA would be to implement a regularly scheduled procedure that checks the current size requirements.

Based on the results, the user could get an alert email or the account could be locked (or something similar).

Besides that it is of course important to be able to limit the amount of runtime memory a user can use for her queries (makes at least the half of all memory, so this is even more important!). And for this SAP HANA provides an option to set memory limits on user basis. Check the admin guide for that.

[former_member186458]

Is this still valid now, in the new XSA HDI container architecture ? are you aware of any means to limit HDI container size ? thomas.jung

[thomas_jung]

HDI containers are logical/security separation. They don't do anything on sizing or DB resource allocation. Within the DB they are basically just schemas.

[former_member186458]

Thanks Thomas. That simplifies the question to "Can we restrict schema size" which i guess is still not possible. The only other option to limit memory for a specific use-case/function is creating a separate tenant DB container for it. is my understanding right ?

thomas.jung

[thomas_jung]

Yes HANA MDC Containers does have strong isolation and resource tuning capabilities. But just e clear that an MDC container is a very different thing from an HDI container.

[former_member186458]

got it. Though on the same server a MDC is setup more like a standalone database with strong isolation/tuning capabilities. and HDI containers are logical self contained apps and doesn't have any means to limit memory utilization. Thanks for the clarification thomas.jung