SQL Server Performance

How can I get time to execute a stored procedure and a number of row return of that stored

Discussion in 'SQL Server 2005 T-SQL Performance Tuning' started by LVK, May 2, 2008.

  1. LVK New Member

    When I execute a stored procedure, how can I get time to execute that procedure ?
  2. Adriaan New Member

    DECLARE @time DATETIME
    SET @time = GETDATE()

    EXEC stored_procedure param1, param2
    SELECT DATEDIFF(ms, @time, GETDATE())
  3. gbd77rc New Member

Share This Page