Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 26 Mar 2015 @ 23:27:37 GMT

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

Subj:   Re: Canary Queries - TO Analyze System response
From:   Clark, Dave


Canary queries are used as the basis for alert mechanisms to know the state of the system but you need to know what you want to measure. Generally they are divided into two categories:

System canaries

o) Check specifically for entire database hung or slowed down

o) Concurrently, capture information from every node about AMP worker tasks, message queues, scheduler allocation, etc.

o) Design canaries so they are never intrusive

            Ex. Select * from dbc.dbcinfo; - an all-AMP, subsecond query

Production canaries

o) Check consistency of response for highest priority or shortest expected responses

o) Check consistency of response within a particular allocation group

o) Query is reflective of the typical workload

In either case, you will want to track/chart canary response against other conditions such as # Sessions, # AMP worker tasks in use and % CPU busy.

Hope this helps.


  <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