Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 04 Nov 2003 @ 06:51:19 GMT

  <Prev Next>  
Next> Last>>  

Subj:   CPU vs IO
From:   Harizanov, Ivan A

Dear All,

I am familiar with the CPU vs IO as per Larry Higa's ratio cputime * 1000 /diskio which is ok when analysing DBC.AMPUsage. I want to do the same against DBC.ResUsagesPma table. There are few columns which I intend to use for IO

* FileWrites - Total number of disk segment immediate or delayed physical writes.

* FileAcqReads - Total number of disk segment acquires that caused a physical read.

* FilePreReads - Total number of disk segment prefetches that caused a physical read.

Which of this columns can be use work out the ratio as per Larry Higa's formula?

If anyone had done simmilar analyses on CPU vs IO using DBC.ResUsagesPma would like to hear from you.

Many thanks

Ivan Harizanov
> EDS Australia

  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020