Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 ClearTrace Support Forum
 Clear Trace Metrics

Author  Topic 

asqldeveloper
Starting Member

17 Posts

Posted - 2013-08-20 : 21:33:55
Clear Trace is a great tool and I sincerely wish it tells what units the measurements are.

I would like to know what are the units of these measurements
CPU
Reads
Writes
Duration

I believe ALL measurements are in Milliseconds? If yes, would the average also be in Milliseconds (I know its a dumb question about average, but dont want to assume when giving performance reports to leadership).

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2013-08-21 : 06:40:26
ClearTrace reports the metrics in the same units that Profiler would capture them. You can see the SQL Server documentation on Profiler or trace for more details.

That said...

CPU is in milliseconds
Reads is logical 8KB page reads
Writes is logical 8KB page writes
Duration is milliseconds for a 2005 trace and microseconds for any version after that. And SMO doesn't report the version or units so i just return the raw number.



=================================================
Creating tomorrow's legacy systems today. One crisis at a time.
Go to Top of Page
   

- Advertisement -