Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Viewpoint High IMPACT CPU
From:   Anomy Anom

<-- 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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023