Archives of the TeradataForum
Message Posted: Tue, 16 Jun 2015 @ 16:14:50 GMT
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 %.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|