SQL Server Performance

no value in duration column using Profiler

Discussion in 'Performance Tuning for DBAs' started by v1rtu0s1ty, Oct 1, 2004.

  1. v1rtu0s1ty New Member

    hey guys,

    I ran profiler in my workstation instead. I used the same events, data columns and started it. I am seeing queries but I am not seeing any values for the duration, reads, writes, cpu. Did I miss anything?

    thanks....

    v
  2. Chappy New Member

    you used the same events and data columns as what ?
    duration is often empty. It should at least be populated for Stmt: completed and Stored Proc: Completed, probably RPC: Completed too I dont recall

  3. v1rtu0s1ty New Member

    It's working now. I also recreated a blocking in 3 query analyzers. I found out that before Profiler can see the duration values, the waiting process has to either cancel her query or she should wait until the blocking process finishes the query.
  4. ibro New Member

    Hello guys...

    I was doing a server side tracing and the duration column in the result set happened to have an empty value? Any ideas?
  5. FrankKalis Moderator

    Instead of replying to a 9 year old thread, please open a new one. Should increase your chances to receive responses.

Share This Page