Archives of the TeradataForum

Message Posted: Tue, 16 Jun 2015 @ 16:14:50 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Forum,

I want to calculate the % of CPU usage from Sum(AMPCPUTime) for the top N queries in the database. The system has 22 nodes , 24 CPUs in each node , 6 cores / CPU. So let?s say the ?sum(AMPCPUTime) for the query is X and let's say it executed for 60 minutes. Is my calculation for % CPU usage correct?

     X /(22*24*6*60*60)*100

     22 - No of nodes
     24 - No of CPU is each node
     6 - No of cores in each CPU
     60 - no of minutes the query executed
     60 - No of seconds

Multiplying by 100 to get the %.

Thanks

Roopalini

	<Prev	Next>		<<First	<Prev	Next>	Last>>