I need to improve the performance in a db that I didn't write, it has
a lot of SP chains where each SP contains a select loop based on a
select from another SP, which I suspect is at least part of the
problem.

I know several tools will show the dependancies of an SP but I want to
extend that to see all levels at once.

Does anyone have a good method or tool that will enable me to
reverse-engineer a tree showing which SP calls which (I did wonder
about a recursive SP on the system tables but I'm not that brave).