SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

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

asqldeveloper
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
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

USA
4137 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  
 New 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.14 seconds. Powered By: Snitz Forums 2000