Post reply

sql time duration of SP with Profilers

  • January 31, 2012 at 5:59 am

    #391437

    I am not an expert with SQL profiler I want to know which sql directive from storage procedure takes the most of time consumption? How to set up MS SQL Profiler 2008 to do that.

    Any tutorial or video might be of help a lot. I have tried and it looks so simple, but it is not.

  • January 31, 2012 at 7:16 am

    #1440621

    trace on the events SP:Starting, SP:StmtStarting, SP:StmtCompleted and SP:Completed. The durations of these events will give you the information you are looking for- duration of the entire proc, and duration of each statement.

  • February 7, 2012 at 8:46 am

    #1443857

    The problem is that I have ticked what you said. Then run my stored procedure which takes about 20 sec, but I do not have anything written in my profiler. What is wrong?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply