Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
Next> Last>>  

Subj:   CPU Usage for a query in %
From:   Bakthavachalam, Roopalini

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 %.



  <Prev Next>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023