I was calling the store procedure and function from some other application and i didnt have the code to know what procedure has been called but the result is taking time to display.

So I want to know what all are the store procedure is been called and how much time takes each one?

Could you please help me to get the result?