Archives of the TeradataForum
Message Posted: Wed, 19 Jun 2002 @ 19:21:24 GMT
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|