Using the power of the SQL Profiler and running a simple trace to capture the performance of your stored procedures can easily obtain these query lists. that needs tuning.
If you have the better answer, then send it to us. We will display your answer after the approval.