Archives of the TeradataForum

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

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

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>>