Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Mon, 17 Mar 2003 @ 15:51:44 GMT





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




Subj:   Re: Canary queries and SQL for performance monitoring
 
From:   Christopher Platt



A lot of what I have seen is people writing an SQL report against a large table and then monitoring how long it actually takes to execute. Tracking and charting this execution time over periods of time. Users/etc.use execution time as a gauge has to how the box is running. Once youto start to publish stats on High and Low execution time people can start to judge query execution based upon the response time of a typical query.





     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
 
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 30 Jun 2008