|
|
Archives of the TeradataForum
Message Posted: Thu, 02 Oct 2003 @ 09:47:31 GMT
Subj: | | Re: PSF Milestone Question |
|
From: | | Thomas F. Stanek |
Clay,
The Milestone Type Parameter is set at the Performance Group, not at the Allocation Group. Therefore, assuming no manual intervention
through the PM/API, the query will be assigned to the Allocation Group associated with the Performance Group at logon and then be handled
according to the Milestone Type rules defined.
One possible exception to this case might be a situation whereby you implement a process that switches your PSF schemes, either based on
some event or at regular time intervals. If, in this scenario, you were to "redefine" your Performance Group such that you change the
Milestone Type from Time to Query, I'm not sure what would happen to any "in-flight" queries. I'm not recommending that, but I'm guessing
that it's possible. Does anyone have any thoughts or insights into this situation? Does PSF continually re-evaluate the definition of
Performance Groups and/or Allocation Groups when computing the relative weighting?
Having said that (and drifted off track), I'm not sure if that answers your question regarding PSF getting "confused" while managing
multiple queries from a single session. If not, fire of a response to this and let us know.
Thomas F. Stanek
TFS Consulting, Inc.
www.tfsconsulting.com
| |