Execution time of functions and procedures | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Execution time of functions and procedures

Hi all,
how to find out the execution time of the functions and procedures in a database.please help me. Thanks&Regards,
Pinky

Declare @datetime datetime
Select @datetime =getdate()
EXEC proc
Select DATEDIFF(second,@datetime,getdate()) as executed_time Madhivanan Failing to plan is Planning to fail

You can also see from the query analyzer taskbar in case you are not familiar.
Name
———
Dilli Grg (1 row(s) affected)
]]>