PROVE IT !!If you know it then PROVE IT !! Skill Proficiency Test

How to find CPU UTILIZATION FOR PARTICULAR TIMEFRAME ?

27 ) How to find CPU UTILIZATION FOR PARTICULAR TIMEFRAME ?

Answer >

SELECT

T1.TheDate( FORMAT ‘yy/mm/dd’ , TITLE ‘// // Date’ ) DATE_1,

T1.TheTime( FORMAT ’99:99:99′ ) TIME_1,

—MAXIMUM ( T1.inusemax ) AWT_MAX_USE

MAXIMUM ( 100 * ( T2.cpuuexec + T2.cpuuserv ) / ( T2.cpuuexec + T2.cpuuserv + T2.cpuidle + T2.cpuiowait ) ) AS CPU_PCT_MAX

FROM PDCRINFO.ResUsageSAWT AS T1

LEFT OUTER JOIN PDCRINFO.ResUsageSPMA AS T2

ON T1.TheDate=T2.TheDate and T1.TheTime=T2.TheTime

WHERE T1.TheDate =’2014-03-28′ — CHANGING THE DATE AS REQUIRED

AND T1.TheTime BETWEEN 224500 AND 235900

GROUP BY 1,2

Add a Comment

Your email address will not be published. Required fields are marked *