• 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.

    That is tricky, I was very certain I got it right (1061 seconds) because I have done too many durations tracking, IN GUI where I want things under 1000 (1 second).

    Thanks for the tip

    SQLServerNewbieMCITP: Database Administrator SQL Server 2005