Post reply

Query Performance issue

  • June 8, 2009 at 2:59 am

    #1005967

    vivek (6/1/2009)

    --Did we tried to capture Execution Plan for the procedure and if yes

    then did we saw any difference? Can you share it with us?

    ** I capture the execution plan of SP,**

    Can you save and post the exec plans please?

    --Did we notice any waittype when called from QA and JOB, if yes what

    is that?

    ** haven't run Profiler**

    Profiler doesn't show wait times. The dmv sys.dm_os_wait_stats shows aggregated wait times and the dmv sys.dm_exec_requests shows the waits per request. What waits are you seeing

    --Can you run Profiler at the back end (during both runs i.e. QA & JOB)

    and share it with us?

    ** Server is under having load, so can't use profiler**

    Use a server-side trace. Much, much less load.

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing post 16 (of 15 total)

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