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
| 
