All Forums Database
usmans 39 posts Joined 01/13
06 Jul 2013
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!

--Regards Usmans
usmans 39 posts Joined 01/13
09 Jul 2013

Any reply on the above?

--Regards
Usmans

dnoeth 4628 posts Joined 11/04
10 Jul 2013

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

Dieter

usmans 39 posts Joined 01/13
14 Jul 2013

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

--Regards
Usmans

gskaushik 56 posts Joined 09/10
26 Sep 2015

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

 
 

Regards
Subramanian kaushik Gurumoorthy

You must sign in to leave a comment.