SQL Profiler 'Duration' Column Scale 2

[Skittle]

The duration column is a key value for analysing the performance of an SQL Server.

I've always viewed it as a relative number to activity.
Has anybody ever identified what the scale means?



Dazed and confused

 

[mrdenny]

I beleive that it's miliseconds.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005) / MCITP Database Administrator (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[Catadmin]

It is displayed in the trace as milliseconds, but in SQL Server 2005, if you're filtering by it, the amount you enter in the "filter field" is by is microseconds. In earlier versions of SQL, you enter a millisecond value in the "filter field".



Catadmin - MCDBA, MCSA
"No, no. Yes. No, I tried that. Yes, both ways. No, I don't know. No again. Are there any more questions?"
-- Xena, "Been There, Done That"

 

[Skittle]

Thanks chaps.


Dazed and confused