How to find the execution time of a stored procedure?

here are two options to find the execution time of the stored procedure,

First Option:
Get the current time before execution. Execute the stored procedure. Get the current time after execution. Manipulate the difference in times which will provide you the exact execution time.

declare @startproc datetime
declare @endproc datetime
declare @time integer
select @startproc = getdate()
exec VenkatProc(Your procedure name)
select @endproc = getdate()
select @time = DATEDIFF(second, @startproc, @endproc)
print str(@time)

Second Option:
Get Use profiler to get the exact time taken + split up period like, time taken by each query + time taken to read or write.

Advertisements

About Asif
Hello Friends… I have done my Bachelor of Engineering in Information Technology from Gujarat University. I have 1.7 years experience of web and windows based application development.. My basic idea to start a blog is to store all important link which help me in my application and access to every where. Also this information is help others who want to makes their application powerful. I am interested in .net framework (1.0,2.0,3.0,3.5 and more). This blog contain also many information related to SQL, Custom Controls in C#.net Please share your ideas and any query if you have...

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: