A workload is a group of queries that share characteristics so that a set of workload management controls can be applied to the group. A workload has working values and defining characteristics that are evaluated during the classification phase of system management. High-quality workload management can improve response times and ensure more consistent response times for critical work. The IWM system has no options for the SLG Tiers workload management method or virtual partitions.
- Batch jobs further subdivided by region or organization for reporting
- Weekly or monthly reports that follow the calendar or a regular schedule
- Jobs that are always critical whenever they occur
- Classification
- Criteria that determine if a query is assigned to the workload
- Throttles
- Limits on the number of concurrent active queries that can run in a workload
- Service Level Goals
- Goals for workload query performance in terms of response time or throughput
- Hold Query Responses
- For Teradata Database 15.10 SLES 11, enforces a delay so query responses are not returned sooner than an amount of time you specify
- Exceptions
- Thresholds and actions to take if a query exceeds exception criteria while executing
WD-Default is a default workload that has queries not classified into a specific workload. The WD-Default workload cannot be deleted or disabled. You can create up to 250 workloads. A workload cannot be deleted if it has associated workload events. Workload events for a workload are created in the state matrix.