Archives of the TeradataForum
Message Posted: Tue, 04 Nov 2003 @ 06:51:19 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|