1. pinky New Member

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

   pinky, Jun 11, 2007

   #2
2. Madhivanan Moderator

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

   Madhivanan, Jun 11, 2007

   #2
3. DilliGrg Member

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

   DilliGrg, Jun 12, 2007

   #2

Please click 'Forgot Your Password' to reset your password if this is your first time using the new forums.

Your name or email address:

Do you already have an account?

Forgot your password?

• No, create an account now.
• Yes, my password is:

Stay logged in