"physicalDisk(_total)\ Avg"的平均值.磁盘秒/写"在performcemonitor UI中不正确吗? [英] The average value of "physicalDisk(_total)\Avg. Disk sec/Write" in performcemonitor UI is not corrected?

问题描述

 我遇到了这个问题.我发现此值与从csv或powershell脚本获得的值不同.

 I encountered this issue. I found this value is not as same as the the one i got from csv or my powershell script.

以下是3种方法:
1双击.blg文件，查看平均"项
2双击.blg文件，右键单击，然后另存为.csv文件.双击.csv文件.使用Excel公式:= Average(startnumber:endnumber)
3个powershell脚本

Here are the 3 approaches:
1 double click the .blg file, looks at the 'Average' item
2 double click the .blg file, right click then save as .csv file. Double click the .csv file. use Excel formula : =Average(startnumber:endnumber)
3 powershell script

$total=0.0
	$singleCounterArrayList=import-counter $filename -counter $counterPath
	foreach ($singleCounter in $singleCounterArrayList)
	{	$total=$total+$singleCounter.CounterSamples[0].CookedValue
	}
	$averageValue=$total/($singleCounterArrayList.count)

推荐答案

感谢您的发帖！

由于此问题与Windows性能计数器有关，请在适当的论坛(例如Windows Server论坛)中发布.如果您对SQL Server数据库引擎有任何疑问，请随时在此处发布以告知我们.

Since this issue is related with Windows Performance Counters, please post in appropriate forums such as Windows Server forums. If you have any questions about SQL Server Database Engine, please feel free to post here to let us know.

谢谢，
春松

Thanks,
Chunsong

这篇关于"physicalDisk(_total)\ Avg"的平均值.磁盘秒/写"在performcemonitor UI中不正确吗?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！