SQL Server Performance Forum – Threads Archive
Execution time of functions and proceduresHi all,
how to find out the execution time of the functions and procedures in a database.please help me. Thanks&Regards,
Declare @datetime datetime
Select @datetime =getdate()
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.
Dilli Grg (1 row(s) affected)