 |
 |
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
| |
