Teradata workload designer portlet on viewpoint helps you to manage and create workloads. As we know, a workload on a system has many parameters attached to it. Any query, before hitting the system, needs to be classified under a particular workload. Once classified, this query goes through a filter check. Imagine this filter as a security guard for a building; he keeps a note of everyone going into a building. And if he has a list of people who are not allowed to enter a building, he will disallow them and stop them from entering the building.
Workload throttle works in the same fashion. Filters stop or give warnings, based on bad queries hitting the system. You can define rules like:
- Block high estimated runtime ...
