Query concurrency data available in Metrics heatmap through DBQL data

Database
Enthusiast

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

Tags (1)
2 REPLIES
Enthusiast

Re: Query concurrency data available in Metrics heatmap through DBQL data

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

Enthusiast

Re: Query concurrency data available in Metrics heatmap through DBQL data

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