Archives of the TeradataForum
Message Posted: Wed, 19 Jun 2002 @ 19:21:24 GMT
| Subj: | | Re: Limits of CPU |
| |
| From: | | Thomas F. Stanek |
The relative and absolute policies are very affective in limiting the amount of system resources for ad hoc queries. As a general
rule, I prefer using the relative policy only because it allows work in the associated performance group to use more of the system
resources if they are available and not being used by other performance groups. However, if other performance groups are active, the
relative policy effectively limits CPU consumption for the performance group. The absolute policy is a hard a fast limit. CPU
resources will not exceed the limit, regardless of the other work on the system.
In both cases, you run the risk of idle CPU time that could otherwise be working on the requests executing in the limited
performance group. Just something to be aware of.
Perhaps you could elaborate more on the types of problems your were having, the policies you implemented, etc.
Thomas F. Stanek
TFS Consulting
WWW.TFSCONSULTING.COM
| 
