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 ,
SandeepiiiAsked:
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.
0
 
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.)

Regards,

Patrick
0
 
SandeepiiiAuthor Commented:
thanks
0
 
SandeepiiiAuthor Commented:
thanks for the answer
0
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.