• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 318
  • Last Modified:

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 ,
0
Sandeepiii
Asked:
Sandeepiii
  • 2
1 Solution
 
chapmandewCommented:
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

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now