Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I'm looking at a Physical Disk\Avg. Disk sec/Transfer counter in perfmon. We've always had faith in the Average number that perfmon reports over the selected time span.

I can't figure out why if I use perfmon to save the data to .csv, or relog the whole blg to .csv the number calculated by '=Average(A:A)' in excel is wildly different than the number reported in the tool. Several people seem to have asked this question in various forums over the years, but I see no answers. Specifically, the Average Avg. Disk sec/Transfer as reported in the perfmon tool is .041, but =AVERAGE(SY:SY) (this is the SY column that contains this data, PhysicalDisk(2 T:)\Avg. Disk sec/Transfer) returns 0.008787746. That's not even in the same ballpark. I even tried an AverageIf to exclude columns with a value of 0...barely makes a difference.

BTW - The counters are being recorded on a Server 2003 32bit machine and analyzed on a Win 7 64 bit machine.

Any ideas?

share|improve this question

1 Answer 1

Strictly speaking, from a math perspective, an average of averages is bad math. Think about it. One average could be on 10 measurements and another on 50. So averaging them together gives too much weight to the first entries and less to the 2nd group.

I don't know if that's what's going on here or not. Have you tried this with some other instantaneous statistic?

Also, perfmon may only be averaging the entries currently on the graph.

\\Greg

share|improve this answer
    
The timespan was the same for both the perfmon view and the data dump. The fact remains though that whatever the sample rate (which was 1 per 20 seconds I believe), one would think that since the same raw data exists for the csv dump and the perfmon graphs/tables, the averages ought to be same (disregarding a small rounding error). –  Bob Apr 21 '11 at 17:52

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.