Archives of the TeradataForum

Message Posted: Fri, 26 Apr 2013 @ 21:42:48 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

<-- Anonymously Posted: Friday, April 26, 2013 15:39 -->

IMPACT CPU is Max AMP CPU for the most recent sample period times number of AMPs. The term "impact" reflects the idea that "the system will only be perceived to be as fast as the slowest (busiest) AMP". DELTA CPU is total CPU consumed across all AMPs during the most recent sample period. Both these values are used primarily to rank / compare queries running concurrently and not as absolute numbers.

PJI or Product Join Indicator is a ratio between CPU consumption and I/O activity. The higher the number, the more "CPU bound" the query (and the more impact it is likely to have on other concurrent work). Ratios near 1.0 are typical for many workloads; anything over 3.0 is worth looking at more closely.

	<Prev	Next>		<<First	<Prev	Next>	Last>>