Post reply

Doubt in Profiler

  • February 1, 2012 at 5:52 am

    #254603

    Dear All,

    I am Running Profiler for finding long running queries on a particular database. It is giving the results.. Here Duration also displaying. Can any body please clarify how it is showing the duration

    like seconds, milliseconds or micro seconds...

    Thanks in Advance...

  • February 1, 2012 at 6:02 am

    #1441166

    Depends on the value of the setting in Profiler. Tools -> Options

    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

  • February 1, 2012 at 6:08 am

    #1441171

    Thank You..

    I found that issue.. It is showing in milliseconds Only, and also I checked what you said...

    Thank you Once again:-)

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

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