Unit of Measurement for Duration Column in Sql Profiler

Question

What is the Unit of Duration column in SQL Profiler? i thought it is milliseconds but in following profiler row i found it contradicting with start and end time

spid=163    
duration=11310646
starttime=2010-04-06 17:45:24.480
endtime=2010-04-06 17:45:35.790
reads=152
writes=2
cpu=16
eventclass=12
textdata= DELETE FROM dbo.[Icon] WHERE Id = 20087 

FYI, I am using sql server 2008

Answer 1

I found the answer here http://msdn.microsoft.com/en-us/library/ms175848.aspx

It says

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

I was watching them after saving the trace file in Database

Answer 2

Correct, In the trace file the Duration column value is stored as Nano seconds...NOT milli seconds