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.
| 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 measurementsCPUReadsWritesDurationI 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 millisecondsReads is logical 8KB page readsWrites is logical 8KB page writesDuration 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. |
 |
|
|
|
|
|
Clear Trace Metrics