TraceTune display Duration in milliseconds. Finally.

SQL Server 2008 started reporting the statement duration in microseconds in scripted traces.  That’s one millionth of a second.  Previously they were reported in milliseconds.  Profiler automatically corrects for this and always displays in milliseconds regardless of the version of SQL Server that generated the trace.  However SMO reported them in milliseconds or microseconds depending on what version of SQL Server generated the trace.  Worse, SMO has no way to tell you what version of SQL Server generated a trace.  Or what unit of measure was used to return the value.

That left me reading traces with no way to figure out the unit of measure for duration. 

After a fair bit of research I’ve finally figured it out and TraceTune now displays all durations in milliseconds.  In case you’re curious, it appears that traces from SQL Server 2008 and higher all start with the characters “FFFE”.

Show Comments