posts - 218, comments - 410, trackbacks - 27

My Links

Advertisement

News

Follow billgraziano on Twitter

Article Categories

Archives

Post Categories

Consulting

SQL Server

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

Print | posted on Tuesday, July 05, 2011 9:20 AM | Filed Under [ ClearTrace ]

Feedback

Gravatar

# re: TraceTune display Duration in milliseconds. Finally.

does this duration display issue also exist in cleartrace? If so, is that also going to get patched? thanks!


7/11/2011 4:35 PM | 7gartner
Gravatar

# re: TraceTune display Duration in milliseconds. Finally.

The duration issue also exists in ClearTrace. I will fix it but I'm not sure when.
7/11/2011 7:21 PM | graz
Comments have been closed on this topic.

Powered by:
Powered By Subtext Powered By ASP.NET