All Forums General
TD_Raj 50 posts Joined 05/10
11 Dec 2013
Same query taking different CPU TIME, RESPONSE TIME

Hi 
 
I am running the same query in Teradata and everytime I am seeing changes in CPU Time and Response Time.
I have tried running the same query in same session as well as in different sessions.
The DELAY TIME is NULL.
Response Time I am calculating by (FIRST RESPONSE TIME - START TIME).
When I say different time I mean varying time and does not mean less time with subsequent execution if running in same session and more time if running each time in different session.
In the same session too , I am getting more time for subsequent runs.
Kindly suggest what can be the possible reasons for different response time every time I run the query.
 
Thanks is advance
Raj

M.Saeed Khurram 544 posts Joined 09/12
11 Dec 2013

Hi Raj,
The response and throughput depends upon a number of factors, at times you might have different workloads running, that might cause different response time for the same query.
 

Khurram

Raja_KT 1246 posts Joined 07/09
12 Dec 2013

Hi,
Did you have a look at the DBQL tables?
Cheers,
Raja

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.