You can group queries that share characteristics into a workload for an Aster system so that a set of workload management controls can be applied to the group.
Service classes are an attribute you assign to each workload to control query prioritization. Consider creating service classes prior to starting this procedure so you can specify the service class when you create a workload.
WD-Default is the default workload that is applied to queries not classified into a specific workload. If you edit the default workload, you can change the service class, but not the predicate.
- Edit or create a ruleset.
- From the ruleset toolbar, click Workloads.
- Next to Workloads, click
. - Enter a name.The workload is enabled by default.
- Create a WHERE clause and select attributes from the list for the workload predicate.When specifying the predicate, you can use existing UDFs, SQL operators, workload management attributes, and AND and OR conjunctions.
- Specify a service class.
- Click Save.
- [Optional] Set the evaluation order for workloads.
- [Optional] Create services classes for workloads.After you create service classes, consider editing existing workloads to apply those service classes.