Archives of the TeradataForum

Message Posted: Wed, 08 Nov 2000 @ 21:43:41 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Claudia,

First off, I agree with Charles G. Carrie did a wonderful job with the white paper. We worked with Carrie quite a bit this past summer as we were developing our Priority Scheduler strategy. In fact, we (Scott Reder of Sears and I) presented some of our findings at Partners 2000.

Remember that Allocation groups are associated with a Resource Partition and are assigned to a Performance Group. The Allocation Group is what defines the behavior of a performance group within a Resource Partition. The other thing to keep in mind is that the Resource Partition is something of a misnomer. The only affect a Resource Partition has on the workload is that it has a weighting, which is applied to all work performed in its performance groups. A Resource Partition in and of itself will not segregate workloads.

The final answer is, based I what you've said, Prioirty Scheduler can definitely do what you are looking for. My suggestion is to play around with the setup to make it work for you.

Tom Stanek
TFS Consulting

	<Prev	Next>		<<First	<Prev	Next>	Last>>