The output from a SQL Server trace in profiler contains the columns CPU and Duration (amongst others). What units are these values in?
+3
A:
CPU is in milliseconds, Duration in microseconds. From this link.
RolandTumble
2009-06-10 16:33:09
Thanks - it was actually a SQL2000 log I was looking at which reports in milliseconds which the link also answered.
PaulB
2009-06-10 16:49:55
Beginning with 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 and later, 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.
jerryhung
2010-03-09 14:52:49