Archives of the TeradataForum

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

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

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>		<<First	<Prev	Next>	Last>>