SQL profiler to capture sp calls

Connect the instance that you want to run the sql profiler.

select the Tuning option

then go to the event selection

Select the SP store procedure to run the RPC completed section only

Filter out the DB name and in the Text box type %spname% .

Then start the Trace

http://www.connectsql.com/2011/10/sql-server-using-sql-profiler-to.html