Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2003
    Irvine, CA

    Unanswered: Setting Duration druing SQL 2k Profiler trace

    I've set the Duration of my trace to "Greater than or Equal to: 1000". However when I start my trace the Duration column is now empty. Prior to the setting, there were values showing in this column. Any ideas on how to fix this?

  2. #2
    Join Date
    Feb 2004
    You've stumbled across a really crap feature of the filters in profiler.
    On many filters , "ApplicationName" is one I try and do, profiler seems to add a logical "OR <field> is blank" onto your criteria. I've just tried out your duration filter and it's the same - you get all those over 1000 ms, and all those with a duration too small to resister on the millisecond scale.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts