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.

  2. Madhivanan Moderator

    Declare @datetime datetime
    Select @datetime =getdate()
    EXEC proc
    Select DATEDIFF(second,@datetime,getdate()) as executed_time


    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.

    Dilli Grg

    (1 row(s) affected)

Share This Page