:::: MENU ::::

Duration value in SQL Server 2005 trace

  • Dec 11 / 2008
  • 0
dbDigger, Monitoring and Analysis, SQL Server tools

Duration value in SQL Server 2005 trace

Question: You make a SQL Trace in SQL Server 2005 and after you have loaded everything into a table you do a select and see the following results:

Duration Reads Writes CPU
1061610 400 0 66

When you look at the duration, what is the value here?

Answer: 1.06161 seconds

Explanation: The answer is 1.06161 seconds.

In SQL Server 2005, the server reports the duration of an event in microseconds (one millionth, or 10-6, of a second) and the amount of CPU time used by the event in milliseconds (one thousandth, or 10-3, of a second). In SQL Server 2000, the server reported both duration and CPU time in milliseconds. In SQL Server 2005, the SQL Server Profiler graphical user interface displays the Duration column in milliseconds by default, but when a trace is saved to either a file or a database table, the Duration column value is written in microseconds.

Consult us to explore the Databases. Contact us