Profiler Trace duration?

• SQL Galaxy

  One Orange Chip

  Points: 29472

  More actions

  August 3, 2013 at 6:21 am

  #297166

  Hi,

  I have transfer data into table from trace file , after that i want check duration of praticulare events..

  I want to know as bleow query display how much milliseond or microsecond from trace table?

  SELECT TextData, Duration, CPU

  FROM trace_table_name

  WHERE EventClass = 12 -- SQL:BatchCompleted events

  AND CPU < (Duration * 1000)

  thanks

  ananda

• Jeff Moden

  SSC Guru

  Points: 1004406

  More actions

  August 3, 2013 at 11:40 am

  #1638427

  ananda.murugesan (8/3/2013)

  ---

  Hi,

  I have transfer data into table from trace file , after that i want check duration of praticulare events..

  I want to know as bleow query display how much milliseond or microsecond from trace table?

  SELECT TextData, Duration, CPU

  FROM trace_table_name

  WHERE EventClass = 12 -- SQL:BatchCompleted events

  AND CPU < (Duration * 1000)

  thanks

  ananda

  I guess I don't understand what that last part of the WHERE clause is for. Are you just trying to find things where parallelism did NOT take place based on a CPU/Duration comparison? If so, that's probably faulty logic since CPU time can still be less than duration even though parallelism took place.

  --Jeff Moden

  ---

  RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
  First step towards the paradigm shift of writing Set Based code:
  ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

  Change is inevitable... Change for the better is not.
  

  ---

  Helpful Links:
  How to post code problems
  How to Post Performance Problems
  Create a Tally Function (fnTally)