All Forums Database
gskaushik 56 posts Joined 09/10
21 Nov 2015
Query concurrency data available in Metrics heatmap through DBQL data

Hi all,
 
I found that we have a portlet called "Metrics Heatmap" which presents the "Query concurrency" for a teradata system.
Kindly do inform if there is any query to find the query concurrency data/
 
Teradata system- 5500
Teradata version - 14.00
 
Thanks in advance for your help

Regards Subramanian kaushik Gurumoorthy
gskaushik 56 posts Joined 09/10
21 Nov 2015

Hi ,
 
Kindly do help me in this regard if we can retrieve the query concurrency details from the DBQL instead of Viewpoint metrics heatmap.
 
regards
Subramanian kaushik Gurumoorthy

Regards
Subramanian kaushik Gurumoorthy

gskaushik 56 posts Joined 09/10
22 Nov 2015

Hi Experts ,
 
I have come up with the query for query concurrency from DBQLLOGTBL_HST
 

LOCKING ROW FOR ACCESS
SELECT 
cast(starttime as date),
EXTRACT( HOUR FROM A.STARTTIME),
AVG(A.COUT)
FROM
(
SELECT 
 STARTTIME,
COUNT( QUERYID) AS COUT
FROM DBC.QRYLOG
GROUP BY 1
) A
GROUP BY 1,2
UNION 
SELECT 
cast(starttime as date),
EXTRACT( HOUR FROM A.STARTTIME),
AVG(A.COUT)
FROM
(
SELECT 
 STARTTIME,
COUNT( QUERYID) AS COUT
FROM PDCRDATA.DBQLOGTBL_HST
WHERE CAST(STARTTIME AS DATE) = DATE-6 
GROUP BY 1
) A
GROUP BY 1,2

 
, but could find that it is not matching with the one available within Teradata Viewpoint > Metrics Heatmap > Query concurrency
Kindly do help me if there is any other formula for getting the Teradata query concurrency from DBQL
Note :-
I am using Teradata 14.00 version
 
 

Regards
Subramanian kaushik Gurumoorthy

You must sign in to leave a comment.