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..
If you have the workload management implemented , if you have the SLA set up there you can find the same using the below procedure
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
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;