Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 31 Dec 2004 @ 10:38:33 GMT


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


Subj:   Variation in Metrics from dbc.ampusage
 
From:   Anomy Anom

<-- Anonymously Posted: Friday, December 31, 2004 00:35 -->

We measure the amount of resource consumed by an SQL using DBC.AMPUSAGE table [ASE Expansion]. What we have noticed is when the same SQL is being executed we are getting different results. We have ensured that only one session of the login is used. Any reason why we should see variations in resource consumed, data demographics being the same?


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: 15 Jun 2023