Time clarification while tuning

• saidapurs

  Hall of Fame

  Points: 3477

  More actions

  August 22, 2012 at 12:30 am

  #263205

  Hi All,

  I have a small doubt while tracing the the T-SQL DURATION.

  In T-SQL DERATION a column name is Duration, it show the time details of Query execution. Let me know it in SECOND or MICROSECOND or MILLISECOND...

  Thanks in advance..

  Satish..

• rVadim

  Hall of Fame

  Points: 3969

  More actions

  August 22, 2012 at 1:06 am

  #1528465

  It's either Milli or Micro depending on the settings in Tools - Options.

  Click on Duration column header and read the info.

  --Vadim R.