SQL 2005 TRACE DURATION

[Tekreader]

Hi,
In order to find procs ran more than 1 minute in sql 2000 we do like this

select * from tracetable
where DURATION/60000 > 1

can anyone tell me what value i should use for 2005 trace duration,Because in sql 2000 it is saved as milliseconds but in sql2005 it is saved as microseconds.

 

[SQLDenis]

a microsecond is a millionth of a second (1 millisecond is a 1000 microseconds). you can figure out the rest

Denis The SQL Menace
--------------------
SQL Server Code,Tips and Tricks, Performance Tuning
SQLBlog.com, Google Interview Questions

 

[ESquared]

If your trace table is really big, this could offer superior performance:

WHERE duration > 60000 -- aka 60,000 milliseconds aka 60 seconds

I'll follow in Denis's spirit and tell you that you have some multiplying by 1000 to do in there somewhere.