Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: High AMP I/O Skew Always
From:   Sirupa Ashok

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>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 24 Jul 2020