Archives of the TeradataForum
Message Posted: Mon, 16 Oct 2012 @ 00:59:11 GMT
| 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
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.