- Beginning with SQL Server 2005, the server reports the duration of an event in microseconds (one millionth, or 10-6, of a second)
- Beginning with SQL Server 2005, the server reports the duration 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
- 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.
Wednesday, 4 February 2015
1.21 - SQL Profiler Trace Duration Units
Always have to look this up so it must be useful: