Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 16 Oct 2012 @ 00:59:11 GMT

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

Subj:   Re: Parallel Efficiency
From:   Newell, Ray

Efficiency has to do with parallelism. 100% means you have all AMPs working at the same level. Since Teradata is a parallel architecture, have high efficiency is good and the workload is evenly distributed. In a parallel architecture your performance is limited by the the busiest AMP.

With CPU busy, you should not start experience performance degradation until you hit around 80% for fluctuating work such as OLTP where the rates can vary quite a bit. In a batch environment you may be able to go as high as 90% since the work flow is more consistent. of course these are just generic guidelines and do not fit every situation.

Also, your performance consistency has a lot to do with wether you have implemented good workload management rules using TASM.

  <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: 28 Jun 2020