When you see time allocated to a proxy procedure in the stored procedure profiler, and you expand it to see the source code, all it can show is the CREATE PROCEDURE definition... utterly useless for the purposes of performance optimization.
If the database has hundreds of proxy procedures, and a few real procedures you are interested in, seeing those hundreds of proxy procedures cluttering up the list is quite an annoyance. It is quite sufficient to see the time spent in those procedures shown against the CALL statements in the real procedures.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.