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