Query for finding the Execution time of SPs

DECLARE @V3 DATETIME
DECLARE @V1 DATETIME
DECLARE @V2 DATETIME
SET @V1= GETDATE()
SELECT CONVERT(TIME,@V1) START_TIME
EXEC SP_NAME @PARAM= ”
SET @v2=GETDATE()
SELECT CONVERT(TIME,@V2) END_TIME
SELECT @V3=@V2-@V1
SELECT CONVERT(TIME,@V3) DIFF

The above query will give an accurate result with start time,end time,execution time…..

Like this:

Be the first to like this post.

This entry was posted on Monday, June 7th, 2010 at 1:32 pm and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.