Archives of the TeradataForum

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

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

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,

Sravan

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