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!
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.
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
WHERE THEDATE = DATE-1
GROUP BY THEDATE,THETIME
ORDER BY THETIME