Solved

time duration stored procedure is taking

Posted on 2008-06-18
4
301 Views
Last Modified: 2010-04-21
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
Comment
Question by:Sandeepiii
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
4 Comments
 
LVL 60

Accepted Solution

by:
chapmandew earned 250 total points
ID: 21812057
You can use SQL Profiler w/ the event SP:Completed to track this....make sure you set a filter on the ObjectName column.
0
 
LVL 92

Expert Comment

by:Patrick Matthews
ID: 21812099
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
 

Author Closing Comment

by:Sandeepiii
ID: 31468303
thanks
0
 

Author Comment

by:Sandeepiii
ID: 21812132
thanks for the answer
0

Featured Post

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Sql Query join multiple table and distinct records 7 32
CROSS APPLY 4 69
View SQL 2005 Job package 16 78
Ideas on migrating very large  system from SQL 2005 to SQL 2014 3 42
I've encountered valid database schemas that do not have a primary key.  For example, I use LogParser from Microsoft to push IIS logs into a SQL database table for processing and analysis.  However, occasionally due to user error or a scheduled task…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In an interesting question (https://www.experts-exchange.com/questions/29008360/) here at Experts Exchange, a member asked how to split a single image into multiple images. The primary usage for this is to place many photographs on a flatbed scanner…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question