Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 31 Jan 2012 @ 09:31:37 GMT


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


Subj:   Different AMP CPU time on same query
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, January 31, 2012 00:09 -->

Hi,

I ran a simple SQL statement (part of bench mark queries) twice on a system on different days.? There are 21% difference on AMPCPUtime between them.?

One takes 652.3, the other 791.7.? It is the same SQL, platform, statistics, network.? No system setting changes at all.? The only difference is overall system CPU busy, but it is under 100%.? I would thought CPU usage of a single query should be relatively consistent on a system.

Has anyone encountered similar situation? Or any reason could make this variation happen?? It is TD13.10 platform


Thanks



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