Post reply

Doubt in DURATION coulmn while trace

  • December 14, 2005 at 10:17 pm

    #110500

    Hi Gurus,

    Good day to everyone...

    How do we check a query / procedure /  index performing well based on DURATION column while using profiler? I dont know how to analyze them, please guide me.

    thanks in advance to your tips.

    cheers

    JK.

    Thanks
    Jay
    http://www.sqldbops.com

  • December 15, 2005 at 10:44 pm

    #609959

    Hi JK,

    To check the performance of the Sproc/Statement using duration, first ensure that the server load does not fluctuates heavily. If possible try being a single user.

    You can take the trace file and provide the same as input for the READ80TRACE tool provided by microsoft. This tool shows you the number of times a statement is executed and the duration.

    You can alter your indexes/queries/procedure and take trace again and give the same as input and check the duration for any improvement. Also, I suggest, try using PerfMon to check various SQL Server performance counters.

     

    Thanks & Regards,
    Ramanathan M.

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

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