SQL Server Performance

Execution time of functions and procedures

Discussion in 'Getting Started' started by pinky, Jun 11, 2007.

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

Share This Page