ResponseTimeMet in DBQL

Database
Highlighted
Enthusiast

ResponseTimeMet in DBQL

ResponseTimeMet indicates if the query met service level goals.

I am querying on DBQLogTbl and found out the value as 'T' for some records and Blank for others.

What is the meaning of blank in this field?Is this no SLA being defined for these queries ?How to find that if any SLA is associated?Also wanted to know what are the permissible values for this column and their meanings.

Just want to know how many of the queries are meeting their SLAs or not..

Tags (1)
6 REPLIES
Enthusiast

Re: ResponseTimeMet in DBQL

Hi Kishore,

If you have the workload management implemented , if you have the SLA set up there you can find the same using the below procedure

exec syslib.WDSlg

Enthusiast

Re: ResponseTimeMet in DBQL

Hi Subramanian,

We are using Teradata 14.10 and this macro does not come as part of DIP script in Syslib.Is this something that has been compiled by DBAs?In that case could you please help me with the queries being referenced in this macro or let me know which DBC tables are being used?

Appreciate your reply on this.

Thanks - Kishore

Enthusiast

Re: ResponseTimeMet in DBQL

Hi Kishore

Do login to primary node of Teradata and run option 2 DIPDEM.

Which would create the requested objects in SYSLIB.

Enthusiast

Re: ResponseTimeMet in DBQL

Sorry,don't have permission  there.

Enthusiast

Re: ResponseTimeMet in DBQL

Hi Kishore,

The above macro executes the below sql in background , have a check

SELECT  WDId (TITLE 'Workload//Definition//ID',FORMAT 'ZZZ9'), 
Completions (TITLE 'Completion//Count',FORMAT 'ZZZ9'),
MinRespTime (TITLE 'Minimum//Response//Time',FORMAT '99:99:99.99'),
MaxRespTime (TITLE 'Maximum//Response//Time',FORMAT '99:99:99.99'),
AvgRespTime (TITLE 'Average//Response//Time',FORMAT '99:99:99.99'),
MetSLGCnt (TITLE 'Met SLG//Count',FORMAT 'ZZZ9'),
(MetSLGCnt/NULLIFZERO(Completions))*100 (TITLE 'Met SLG//Percent',FORMAT 'ZZZ9')
FROM TABLE (TDWM.TDWMSummary()) AS t1
ORDER BY 1;
Enthusiast

Re: ResponseTimeMet in DBQL

Hi Subramanian,

Thanks for the macro.I think the output from TDWM.TDWMSummary()  table function is  valid for that collection interval, which is typically 30 or 60 seconds.

If I were to do a historical trend analysis of SLG met (say for 1 day) vs misses,

this is not the  best possible approach.I am just wondering if I could use DBQL for that purpose.Any ideas,suggestions??