[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 641
  • Last Modified:

SQL Profiler duration long

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?
0
Wipfli
Asked:
Wipfli
1 Solution
 
MohammedUCommented:
2005 BOL: Duration is now stored in microseconds
ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/udb9/html/d1116086-0613-4de5-91a0-1fb6819894f6.htm
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now