In SQL Server 2000, the server reported both duration and CPU time in milliseconds.
Beginning with SQL Server 2005, the server reports the duration of an event in microseconds and the amount of CPU time used by the event 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.
