Manage Workload Class [Hands-On]

Overview:

Managing Workload Classes

You can manage workload in SAP HANA by creating workload classes and workload class mappings to automatically apply appropriate predefined resource limits.

You can create workload classes and workload class mappings either in SAP HANA Cockpit or using the SQL command line and use these to regulate the resource usage of applications with regard to CPU and memory consumption. The limits defined in a workload class are applied on the basis of session variable values submitted by client applications. These are evaluated by the workload class mapping and the resource limits defined in a matching workload class are then applied to all requests submitted by the application.

Workload class properties for total statement memory limit and total statement thread limit support hierarchical relationships so that workload limits defined for a parent can be inherited by the children. Further details of how this is applied are given in the following topics Create a Workload Class and Hierarchies of Workload Classes in the SAP HANA Cloud, SAP HANA Database Administration Guide.