How to Trace Procedure execution time?
===

I have some procedures which are not optimized . I want to analyse that whether these procedures get optimised or not , as there are only not bulk data to check. 

I want to put a sql query into all the procedure which will insert in to one table that what is exact time taken by the above query to execute. I will create a table in which my procedure will insert the query execution time. 

Is there any way that I can do this. 

Please help me out.

Thanks,

Nitesh Kumar
