SQLTeam.com | Weblogs | Forums

Unit of measure for duration Column in Sql trace table


#1

Hi folks,

i have inserted the profiler trace .trc file to a sql table with the query below.

SELECT * INTO MyTraceTemp

FROM ::fn_trace_gettable('c:\x\MyTrace.trc', default)

there is a duration column not sure if this is in micro or milli seconds.

please advise.

thanks.


#2

The duration (in microseconds)

https://msdn.microsoft.com/en-us/library/hh245121.aspx