I ;ve been using SQL Profiler to troubleshoot performance issues. This is just one row of the sql trace.
This select statement :
SELECT * FROM SLXTRIGGERS WHERE enabled = 'T' AND table_name = 'ACTIVITY' ORDER BY type,sequence
Had a duration of :980985
with a start time of 2008-02-07 15:04:19.160
and an endtime of 2008-02-07 15:04:20.127
In SQL profiler the duration is in ms so this query supposedly took 980 seconds. But if you look at the starttime and endtime it would have only lasted 1 second. So which is right? Did it take 980 seconds or 1 second?