time duration stored procedure is taking

Can i know particular stored procedure is taking time to execute .
Basically want to know how much time it takes to complete.
Iam using sql server 2005 std edition ,
Who is Participating?
chapmandewConnect With a Mentor Commented:
You can use SQL Profiler w/ the event SP:Completed to track this....make sure you set a filter on the ObjectName column.
Patrick MatthewsCommented:
Hello Sandeepiii,

Another way would be to log the steps your sproc is taking in a "log table".  For example, you could insert
a row at the start of the procedure and at the end of the procedure, each time using GETDATE() to populate
a time stamp.  (You could also log intermediate steps if you are so inclined.)


SandeepiiiAuthor Commented:
SandeepiiiAuthor Commented:
thanks for the answer
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.