I have transfer data into table from trace file , after that i want check duration of praticulare events..
I want to know as bleow query display how much milliseond or microsecond from trace table?
SELECT TextData, Duration, CPU
WHERE EventClass = 12 -- SQL:BatchCompleted events
AND CPU < (Duration * 1000)