Monitoring %CP

snassimr · Post by **snassimr** » Tue Aug 30, 2005 9:49 am

Hi !

In Monitoring Window of Director I can See %CPU .

What the value is shown after the job finished ? Max value of cpu usage,average,minimum during the job's run ?

ArndW · Post by **ArndW** » Tue Aug 30, 2005 10:43 am

snassimr,

it shows the average; taking the ratio of Wall-Clock time and CPU time used.

ray.wurlod · Post by **ray.wurlod** » Tue Aug 30, 2005 4:37 pm

Be aware that this value - and the rows per second value - is skewed by operational overheads and sampling interval. The shorter the job the worse are these biasing effects.

ArndW · Post by **ArndW** » Tue Aug 30, 2005 11:43 pm

Ray is quite right, plus the %cpu value does not take multi-cpu systems into account. I had a job yesterday loading 1million rows per minute into Oracle showing a very high %cpu value (sampling interval in PX of 5million rows) but since the system has 10 physical processors the real load on cpu was minimal while the I/O was used to the maximum.