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 Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020