Wednesday 4 February 2015

1.21 - SQL Profiler Trace Duration Units

Always have to look this up so it must be useful:

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

No comments:

Post a Comment