Archives of the TeradataForum

Message Posted: Thu, 12 Oct 2012 @ 00:12:30 GMT

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

Roopalini-

As a starting point, you can examine ResUsage:

Calculating parallel efficiency using ResUsage

The ResNode macro (DBC.ResGeneralInfoView) provides the following:

     /* Parallel efficiency of total pct of time CPUs were busy */
     (AVG(CPUBusy)*100)/NULLIFZERO(MAX(CPUBusy))
     (FORMAT 'ZZ9', TITLE 'CPU//Eff//  %'),

     /* Parallel efficiency of the logical device IOs */
     AVG(LogicalDeviceIOKB)*100 / NULLIFZERO(MAX(LogicalDeviceIOKB))
     (FORMAT 'ZZ9', TITLE 'Ldv//Eff//  %'),

-dave.clark

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