• A trace is the best way to figure out what's being used, and that won't tell you what isn't being used, but it will help. You do need to run it over time to make sure that you get most procs.

    Even then, what's the point? Are you looking to remove procedures? They don't take up much space and don't impact the system if they're not being used.

    If it's cleanup, I think you would be better off spending time doing something else. If you have other reasons, you can always rename some procs and see if anything breaks. That way you'll have the code around and can "restore" them if there's an issue.