All Forums Database
Kishore_1 208 posts Joined 03/10
23 Sep 2015
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..
 

gskaushik 56 posts Joined 09/10
26 Sep 2015

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

Regards
Subramanian kaushik Gurumoorthy

Kishore_1 208 posts Joined 03/10
26 Sep 2015

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

gskaushik 56 posts Joined 09/10
26 Sep 2015

Hi Kishore
 
Do login to primary node of Teradata and run option 2 DIPDEM.
Which would create the requested objects in SYSLIB.
 
 

Regards
Subramanian kaushik Gurumoorthy

Kishore_1 208 posts Joined 03/10
26 Sep 2015

Sorry,don't have permission  there.

gskaushik 56 posts Joined 09/10
26 Sep 2015

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;

 

Regards
Subramanian kaushik Gurumoorthy

Kishore_1 208 posts Joined 03/10
27 Sep 2015

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??

You must sign in to leave a comment.