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)
]]>