Archives of the TeradataForum

Message Posted: Thu, 20 Jun 2013 @ 22:15:24 GMT

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

Hi Dave Clark,

I ran the following query from your scripts this showing me high 'Virtual Disk Use Skew %' and this number exactly equal to the 'High AMP I/O Skew' on the view point.

Could you suggest what could be the reason how to avoid this skew.

     SEL  CAST((HiDiskAmpProc/32)*100 AS INTEGER) + (HiDISKAmpProc MOD 32)
               (TITLE 'High Disk//Node', FORMAT 'ZZ9-99'),
          HiDiskAmpNo (TITLE 'High Disk//Use Amp', FORMAT 'ZZZZZ9'),
          HiDiskAmp (TITLE 'High Disk Use %', FORMAT 'ZZZ,ZZZ,ZZ9.99'),
          AmpAvgDisk (TITLE 'Average Disk Use %', FORMAT 'ZZZ,ZZZ,ZZ9.99'),
          (100 * (1 - (AmpAvgDisk / NULLIFZERO(HiDiskAmp))))
             (TITLE 'Virtual Disk//Use Skew %',FORMAT 'ZZ9') FROM TABLE
     (SYSLIB.MonitorVirtualSummary()) AS t1 WHERE HiDiskAmp > 0;

Appreciate your Help.

Thank you.

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