Real environments have multiple consuming applications that have varying workloads and usage patterns. All of them will have their corresponding service level objectives or SLAs, so it's very important to define workload management plans in the data virtualization layer in order to ensure that SLAs are consistently met.
Denodo Platform provides mechanisms for limiting the maximum used resources in the overall server, including:
Besides that, Denodo Platform allows managing (and limiting if needed) the memory consumed by the execution of a particular view. This can be done through the max.memory and swapping settings of the view. It is also possible to set a global memory limit for the execution of any query in the server or in a particular Virtual DataPort database. This provides a simple and general setting to guarantee no query can monopolize server resources
Denodo Platform 8.0 extends and simplifies resource management capabilities with the Resource Manager: a UI-based tool included in the Virtual DataPort Administration Tool to enforce workload management policies (plans and rules) for dynamically limiting the usage of resources in function of priorities.
Using the Resource Manager, administrators can create a full set of rules which will allow them to dynamically assign resources (CPU, memory, priority) to queries based on criteria such as business priorities. For example, based on the role of the user executing the query or the type of client used to connect to Virtual DataPort.
Denodo Administrators will find how to use the Denodo's Resource Manager and see several examples of its usage: