Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 30 Mar 2015 @ 09:08:30 GMT

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

Subj:   Re: Canary Queries - TO Analyze System response
From:   Sravan.Bodla

Dear all,

Thanks for all your replies.

Completely agree that, the question is bit vague and cannot provide a direct solution.

Hi Dave,

I am looking for my system response at various intervals. But, as u said, I should also look at the response time of same sample query in various workloads at different times. Trying this from PDCR now.

I was using "Sel * from DBC.DBCinfo" which is an all amp query and was running in DEFAULT workload.

I could see like, PDCR is collecting some information and storing in PDCRDATA . Canary_Hst. (A sample query runs in different workloads for every 10 minutes).

As PDCR is much organized, smoothened and completely automized, I would like to go with PDCR canary queries to get this.

If someone is already following PDCR Canary data at their site, can you advise me how to get the information which am looking for (Good, Ok, Bad response times)?

Thank you,


  <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: 24 Jul 2020