How to Calculate the total IO used by System for a particular week

Database
Enthusiast

How to Calculate the total IO used by System for a particular week

Hi Everyone,

The last week was a very busy one on my project. I saw AWTs being consistently used in the range of 60-70. I have calculated the CPU Utilization for the time period mentioned. The client has now requested me to send him an IO Report (Report should include the total IO Used during the past week).

Any ideas as to where I can find that information?

Also if you could share the query, it would be most helpful. I have an idea that the Higa Macros could also be helpful in this regard, but am unsure of which Higa Macro would be the most helpful.

Your suggestions and help would be most welcome!

4 REPLIES
Enthusiast

Re: How to Calculate the total IO used by System for a particular week

Any reply on the above?

Junior Contributor

Re: How to Calculate the total IO used by System for a particular week

Depending on the level of details it's probably Table:ResUsageSpma, View:ResGeneralInfoView and Macro:ResNode.

(FileAcqReads + FilePreReads + FileWrites) is the number of IOs.

Regarding Larry Higa's macros: ResPma

It's probably based on the same info as the CPU calculation you already did.

Dieter

Enthusiast

Re: How to Calculate the total IO used by System for a particular week

Thanks Dnoeth, I'll check it out and will get back to you on this.

Cheers

Enthusiast

Re: How to Calculate the total IO used by System for a particular week

Hi Dnoeth/all,

I tried executing the below within resusagespma table and the IO is not matching with the values in viewpoint.

SELECT THEDATE AS RUNDATE,
CAST(CAST(CAST(THETIME AS FORMAT '99:99:99.99')
AS CHAR(11)) AS TIME(6)) AS RUNTIME,
cast(sum(FILEACQREADS+FILEPREREADS+FILEWRITES) as bigint )/1000000 AS TOTALIOREADS_IN_MILLION
FROM DBC.RESUSAGESPMA
WHERE THEDATE = DATE-1
GROUP BY THEDATE,THETIME
ORDER BY THETIME