Archives of the TeradataForum
Message Posted: Mon, 30 Mar 2015 @ 09:08:30 GMT
Thanks for all your replies.
Completely agree that, the question is bit vague and cannot provide a direct solution.
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)?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|