diff between start time & end time

• connect_ninad

  SSC Enthusiast

  Points: 142

  More actions

  December 3, 2007 at 6:04 am

  #201377

  Dear All,

  I have generated a trace in sql 2000 and i want to find out which queries are r taking more than 30 secs. I have taken starttime,endtime and duration fields.

  Plz help.

  regards,

  Ninad

• MarkusB

  SSC-Dedicated

  Points: 37370

  More actions

  December 3, 2007 at 7:38 am

  #756472

  Just add a filter to your trace which filters on duration > 30000.

  You must use 30000 because the duration is measured in milliseconds.

  [font="Verdana"]Markus Bohse[/font]