Archives of the TeradataForum
Message Posted: Fri, 19 Jun 2015 @ 12:34:29 GMT
I was looking for similar info on Total Available CPU and Disk IO to create a system dashboard. But I couldn't find any info on Total Disk IO available.
There were some suggestions only on calculating Total Disk IO done for the CPU used. In simple words - time taken by each Disk IO.
Lesser the Average time for Disk IO, more good is the system/workload.
Generally, CPU time of less than 2 ms per IO is considered good.
So, as per my understanding there is no Total Available Disk IO as such.
Please correct if I am wrong.
This is how I calculated system and Account level CPU and IO Performance.
System level CPU from ResUsageSpma.
SUM(CPUUExec) As TotalUserCPU SUM(CPUUServ) AS TotalSystemCPU TotalUserCPU + TotalSystemCPU AS TotalCPUUsed (SUM(CPUUServ+CPUUExec)/SUM(CPUIdle+CPUIoWait+CPUUServ+CPUUExec)*100) AS CPUBusyPercent(System+User)
Total IO Done:
SUM(FileAcqReads+FilePreReads+FileWrites) AS TotalPhysicalDiskIO SUM(FileAcqs+FileWrites+FilePres) AS TotalLogicaDiskIO
TotalCPUUsed /TotalPhysicalDiskIO gives Time taken for each diskIO
Account/User level CPU from AmpUsage.
Sum(cputime) as AccountCPUUsed AccountCPUUsed /(TotalUserCPU from ResusageSpma)*100 gives Account CPU Used Percentage Sum(diskio) as UserLogicalDiskIO CPUUsed /UserLogicalDiskIO gives Time taken for each LogicalDiskIO
There is no physical IO values in AmpUsage, so have to do some comparisons with ResusageSpma IO values to get some approx. Physical IO rates.
Please let me know if anything is wrong in above calculations. This will help me to correct my dashboard.
This dashboard I use to report Daily and Hourly CPU/ IO usage at system level and also on individual accounts level to higher management.
Thanks & Regards,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|