Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 23 Mar 2003 @ 18:21:28 GMT


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


Subj:   SUPER v2r5 Upgrade DBQ Log
 
From:   Harold D Kleven

While we're initially disappointed that very few of the metric columns are maintained in the DBQ tables, we've already found them useful to helping a team examine their queries for performance chokepoints! By using only the basic Qlog table and the QStep table we can help determine where the time is being spent. Yea, an EXPLAIN would help tell that, too, but when there's a dozen or so queries in a SP and the developer didn't bother to parcel out the individual SQL and do an EXPLAIN, this helps track it down! And when the queries involve a lot of Global Temporary Tables, which they are NOT collecting statistics on, this helps even more. Our THANKs to the folks for developing this... now just provide the CPU and IO metrics, too!



     
  <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