In Teradata Database 14.10 and later, you can specify values or use the default system values to throttle queries consuming excessive memory. In system settings, you can create memory groups that are available for query characteristic classification. The settings apply to the whole system, not individual rulesets. Changes take effect after the next ruleset is activated.
- From the Workload Designer view, click System Settings.
- Select the Specify custom values check box and enter a value for one or more of the following threshold options to set the estimated memory use:
Option Description Very Large Must be greater than the Large threshold Large Must be greater than the Increased threshold Increased Must be less than the Large threshold - Click OK.