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

Our new SQL Server Forums are live! Come on over! We've restricted the ability to create new threads on these forums.

SQL Server Forums
Profile | Active Topics | Members | Search | Forum FAQ
Save Password
Forgot your Password?

 All Forums
 Other Forums
 ClearTrace Support Forum
 Clear Trace Metrics
 Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

Starting Member

17 Posts

Posted - 08/20/2013 :  21:33:55  Show Profile  Reply with Quote
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

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).

Chief SQLTeam Crack Dealer

4149 Posts

Posted - 08/21/2013 :  06:40:26  Show Profile  Visit graz's Homepage  Reply with Quote
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
  Previous Topic Topic Next Topic  
 Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.02 seconds. Powered By: Snitz Forums 2000