 |
 |
Archives of the TeradataForum
Message Posted: Wed, 08 Nov 2000 @ 19:23:25 GMT
| Subj: | | Re: Experiences with the Priority Scheduler? |
| |
| From: | | Thomas F. Stanek |
Claudia,
I am working with a major retailer and we have implemented the exact type of workload management strategy that you are looking.
Priority Scheduler will definitely be able to do what it is you want. The schmon utility allows you to change the configuration of
the Priority Scheduler dynamically. The Priority Scheduler has a milestone limit feature that allows you to automatically change an
allocation group based on the time of day, but we found this somewhat limiting in that it did not recognize weekends, holidays,
month-end requirements, etc. Instead, we set up scheduled UNIX scripts that execute based off a schedule. In fact, one of our
systems is configured so that it changes the Priority Scheduler scheme based on triggered events such as nightly batch completing.
This has taken a small amount of programming but the results have been excellent.
Regarding switching the definition of an allocation group while a query is running, this is not a problem at all. If you use
PMON, you already have the ability to change a priority for a query. In affect, changing the Priority Scheduler Scheme while a query
is running has the same affect.
I would strongly suggest that you do a lot of testing before implementing into a production environment. There are a lot of
intricacies to setting up the Resource Partitions, Performance Groups, Allocation Groups, etc. Unfortunately, the documentation in
the manuals doesn't give you much guidance.
Tom Stanek
TFS Consulting
| |
