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 |
|
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).aspxTara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
rsconroy
Starting Member
2 Posts |
Posted - 2011-03-07 : 11:07:11
|
| Tara, Many thanks for sharing that information.Cheers! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
|
|
Statistic Metrics