You can translate the question and the replies:

Resource Manager - Limit per user

I did [this configuration](https://community.denodo.com/answers/question/details?questionId=9064u000000CfAjAAK&titleResource%20Manager%20-%20Limit%20by%20user) in my resource manger and didn't worked. for exemple, I intent to have maximum 5 queries per user and not maximum 5 queries running in the server. what's happening for my is: user 1: running 2 queries user 2: running 2 queries user 3: running 1 query user 4: **waiting** 1 query user 5: **waiting** 1 query what I intent: user 1: running 5 queries - 1 **waiting** user 2: running 2 queries user 3: running 1 query user 4: running 1 query user 5: running 1 query user 6: running 5 queries what can I do in order to have the correct treatment ?
user
25-02-2021 09:07:23 -0500

1 Answer

Hi, In order to limit the number of queries executed by particular users, I would do the following, * In Resource Manager, create a Plan for each user to set the number of concurrent queries to 5. * Then a Rule for each plan, with the condition, "user_name = '<username>'". * With this, I will be able to execute concurrent queries from multiple users. For more information on setting up the Rule condition, have a look at [Resource Manager: Available Fields to Evaluate a Rule](https://community.denodo.com/docs/html/browse/latest/en/vdp/administration/appendix/resource_manager_available_fields_to_evaluate_a_rule/resource_manager_available_fields_to_evaluate_a_rule#resource-manager-available-fields-to-evaluate-a-rule) section of Virtual DataPort Administration Guide. If you need further assistance and if you are a user with valid support access, then you can raise a support case in [Denodo Support Site](https://support.denodo.com/), so that our support team can help you. Hope this helps!
Denodo Team
26-02-2021 05:59:00 -0500
You must sign in to add an answer. If you do not have an account, you can register here