• Also keep in mind that RPC completed is fired when the application calls a procedure directly procedure. If the application calls a procedure which then calls the one you're investigating, there won't be an RPC complete for it (there will be a module_end event), but the execution count will still go up as the procedure is being run.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass