Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 23 May 2008 @ 08:53:46 GMT

  <Prev Next>  
Next> Last>>  

Subj:   Help for Canary Queries
From:   Parija, Soumya Ranjan

Hi All,

Can anyone send me some SQL scripts to check the Teradata System Performance.

Normally they are called as Canary Queries.

These Canary Queries can be segregated to Prodcution Canary and System Canary.

The information captured includes, for example:

- Information on AWTs

- Message queue lengths

- System Activity Reporter (sar) output

- Process queue lengths

- BYNET stats

Thanks in advance.



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