• I, as some of the other posts here have suggested, would go for repeated calls to the DMV over a long period of time (a few weeks at the least to find SP's called once weekly or once monthly).

    If you are going to use trace then at many sites the RPC:Starting event should also be included as well as the SP:starting event you chose.

    Nice article!

    Brett Hawton

    Idera Product Architect