Changing and managing filters
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 queries
- Block queries on selected objects
- Block queries with certain join times
- Block queries with high row estimations
- Block queries from specific users or IPs
It is recommended to create a filter in warning mode first before aborting queries, so that you...
