Unanswered: Profiler - tracing the called procs & Fns
I am trying to look for some performance statistics on my application and intend to find out the procs/fns being called the maximum number of times and also the ones that take long time to run. I selected the following events
Stored Procedures- RPC:Completed
T SQL- SQL:BatchCompleted
I intend to get the information about the called sps/fns also.
Assume Proc1 calls Fn1.
Currently Fn1 does not show up in my trace. I intend to get this info also without getting too much of other information.
Can someone tell what option am I supposed to select for that?