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
 Statistic Metrics

Author  Topic 

rsconroy
Starting Member

2 Posts

Posted - 2011-03-04 : 13:00:02
I was wondering if there is any documentation in regards to the weight or value of what these measurements are. In other words, what am I looking at?

E.g.
AvgCPU 1,563 - Threshold or Usage?
Reads 21,918 - Is this actual calls?
Duration 4,510,204 - Is this milliseconds?
…and so on.

It would be great to have definitive guide to all of the columns.

Thanks!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-03-04 : 13:44:32
This data is from a trace, so whatever these mean in traces is what they mean in CT.

For CPU, it's number of milliseconds spent using the CPU. For CT, it's summed it up.
For Reads, it's number of logical disk reads. For CT, it's summed it up.
For Duration, it's microseconds. For CT, it's summed it up.

AvgCPU is therefore the average of the CPU column.

Here's the documentation for traces: http://msdn.microsoft.com/en-us/library/aa173882(v=sql.80).aspx

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

rsconroy
Starting Member

2 Posts

Posted - 2011-03-07 : 11:07:11
Tara,

Many thanks for sharing that information.

Cheers!
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-03-07 : 13:19:28
You're welcome, glad to help.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -