Finding stored procedures and the time required for same

You may want to refer to sys.dm views and functions for example

Select * sys.dm_exec_query_stats to find those taking the longest to perform. This reports among other items the Total elapsed time, in microseconds, for completed executions of the query plan.

For an explanation of the data returned refer to BOL

ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/eb7b58b8-3508-4114-97c2-d877bcb12964.htm

Querying this and other sys.dm views and functions might yield you the data you need in the shortest period of time and with the least additional work load on the server.