For details about using Teradata Viewpoint portlets, see
Teradata® Viewpoint User Guide, B035-2206. Workload Designer is a workload management portlet.
-
In the Viewpoint Workload Designer portlet, create a ruleset using the following values.
Field Value Name SQLEAnalyticFunctionThrottle Description Ruleset - throttle to limit SQLE Analytic functions concurrency to 4 -
Create a new system throttle using the following values.
Field Value Name CPU and Memory Intensive. Description Set concurrency limit 4 for all SQLE Analytic Functions. Rule Type Select Collective: one queue for all matched queries. -
Set classification criteria for a system throttle using the following values.
Field Values Add Classification Criteria Select Target. Target Type Select Function. Database Select TD_SYSFNLIB. Functions Select and include using the Include button: - DECISIONFORESTPREDICT
- DECISIONTREEPREDICT
- GLMPREDICT
- MOVINGAVERAGE
- NAIVEBAYESPREDICT
- NGRAMSPLITTER
- SVMSPARSEPREDICT
- ATTRIBUTION
- NPATH
- PACK
- SESSIONIZE
- STRINGSIMILARITY
- UNPACK
- ANTISELECT
Included Functions Due to character length, the NAIVEBAYESTEXTCLASSIFIERPREDICT function is abbreviated using a wildcard: NAIVEBAYESTEXTCLASSIFIERPREDI* and cannot be included from the Functions list. Instead, include it directly. -
Add state-specific settings using the following values.
For this example, we use the value 4.
Field Values Concurrency Limit - Select the blank field and type 4.
- Select Delay.
- Activate the ruleset.