Hi, I am a little confused in how to setup a simple workload period and configure it for changes to allow different workloads to have different resource allocations at different times of the day. I have reviewed the Workload Designer section of the User guide but it just confuses me.
In TDWM, we used to set up operating periods, which were then associated with workloads, but this does not seem to be the case with Workload Designer.
So far, I have configured a new Planned ENV, called Business_Hours, which is to allow for setting up different resource allocations for workloads based on if they are running during the hours of 0800 - 1900 and then leaving the Always to cover all other hours - normally would call batch window. Since I am just looking at a simple instance of this, there is no difference in the states required, but i have created a state called Bus_Hours anyway, with the same settings as BASE.
Now when I go to Workloads, there does not appear to be anywhere to change the TYPE (Priority, Normal, Background) depending on which environment. The only place I seem to be able to make changes is in the Priority Distribution section, which seems to only allow you to change the CPU % of the 3 previous allocation groups.
Is this how you set up what I require?
Bus_hours:- Priority 10%, Normal 6%, Background 4%
BASE:- Priority 4%, Normal 6%, Background 10%
This seems completely changed from how we used to allocate different workloads to the allocation groups, based on the period of day.
Thanks, you were right about the Allocation Groups. I visited another Teradata site and got put back on the right track by reviewing how their system was setup.