cpu utilization for procedures


cpu utilization for procedures

Hi All,


i am trying to find the cpu utilization for stored procedures. i obsevred that all system metric columns(i/o,ampcu,spoolusage) values are zero only for procedures. but i am able to see all system metric(i/o,ampcu,spoolusage) values for all others statements such as insert/update/delete/stats.


Teradata Employee

Re: cpu utilization for procedures

I presume you are referring to DBQL?

Use the SessionID, RequestNum, and CallNestingLevel to associate the individual SQL statements executed by the procedure with the CALL.