17.10 - Example: Creating a TASM Ruleset to Limit SQLE Analytic Function Concurrency - Advanced SQL Engine - Teradata Workload Management

Teradata Vantage™ - Workload Management User Guide

Product
Advanced SQL Engine
Teradata Workload Management
Release Number
17.10
Release Date
July 2021
Content Type
Administration
User Guide
Publication ID
B035-1197-171K
Language
English (United States)
For details about using Teradata Viewpoint portlets, see Teradata® Viewpoint User Guide, B035-2206. Workload Designer is a workload management portlet.
  1. 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
  2. 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.
  3. 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.
  4. 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.
  5. Activate the ruleset.