cpu utilization for procedures

Database
Enthusiast

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.

 

1 REPLY
Highlighted
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.