Example: TDWM.WorkloadPlanEnvV - Teradata VantageCloud Lake

This example retrieves details of workloads in the ruleset 'TestConfig' with names containing 'DBA' or 'Load'.

Query

SELECT
WorkloadId,
WorkloadName,
PlannedEnvironment,
WorkloadType,
ServiceLevelGoal,
SLGAllocation,
OtherOption
FROM TDWM.WorkloadPlanEnvV
WHERE RulesetName = 'TestRuleset'
AND (WorkloadName like '%DSSPROF%' OR WorkloadName like '%TDaaS%')
ORDER BY RulesetName, PlannedEnvironment, WorkloadName;

Output

 WorkloadId  WorkloadName                    PlannedEnvironment              WorkloadType    ServiceLevelGoal      SLGAllocation  OtherOption
-----------  ------------------------------  ------------------------------  --------------  --------------------  -------------  -----------
         96  TDaaS_Critical                  Always                          SLG1            NONE                  60.0           -Expedited
         98  TDaaS_High                      Always                          TSHigh          NONE                  ?              ?
         97  TDaaS_Important                 Always                          SLG2            NONE                  55.0           ?
         99  TDaaS_Low                       Always                          TSLow           NONE                  ?              ?
        100  TDaaS_Medium                    Always                          TSMed           NONE                  ?              ?
        102  WD_DSSPROF1_SLG1                Always                          SLG1            100% @ 5 seconds      25.0           +Expedited
        103  WD_DSSPROF3_SLG3                Always                          SLG3            90% @ 3.5 seconds     25.0           ?
        104  WD_DSSPROF4_SLG4                Always                          SLG4            40 rph                25.0           ?
        105  WD_DSSPROF5_SLG5                Always                          SLG5            NONE                  25.0           ?
        226  WD_DSSPROF6_TS                  Always                          TSMed           NONE                  ?              ?
         96  TDaaS_Critical                  UserDefEnv                      SLG1            DEFAULT               60.0           -Expedited
         98  TDaaS_High                      UserDefEnv                      TSHigh          DEFAULT               ?              ?
         97  TDaaS_Important                 UserDefEnv                      SLG2            DEFAULT               55.0           ?
         99  TDaaS_Low                       UserDefEnv                      TSLow           DEFAULT               ?              ?
        100  TDaaS_Medium                    UserDefEnv                      TSMed           DEFAULT               ?              ?
        102  WD_DSSPROF1_SLG1                UserDefEnv                      SLG1            DEFAULT               20.0           +Expedited
        103  WD_DSSPROF3_SLG3                UserDefEnv                      SLG3            75% @ 5 seconds       20.0           ?
        104  WD_DSSPROF4_SLG4                UserDefEnv                      SLG4            25 rph                20.0           ?
        105  WD_DSSPROF5_SLG5                UserDefEnv                      SLG4            DEFAULT               20.0           ?
        226  WD_DSSPROF6_TS                  UserDefEnv                      TSLow           DEFAULT               ?              ?