通过powershell读取性能计数器

读取指定文件夹里性能计数器文件的信息,取出各个counter的平均值,存储在csv

 

param($folderPath="")

function funhelp()
{
$helpText=@"
NAME: PerformanceCounterCalculation)_multipleFile.ps1
This script will loop all the counters and calcualte the average value
PARAMETERS:
-$folderPath Specifies the folder of the .BLG you want to get
SYNTAX:
PerformanceCounterCalculation)_multipleFile.ps1 -folderPath "c:\disk\*"
"@
Write-Host $helpText -ForegroundColor Green
exit
}

#define PerformanceCounter CLASS
 $source = @"
    public class PerformanceCounter
    {
        private string computerName;
  private string counterPath;
        private double value;
     private  string date;
        public PerformanceCounter(string computerName,string counterPath, double value,string date)
        {
  
  this.computerName = computerName;
            this.counterPath = counterPath;
            this.value = value;
   this.date=date;
           
        }
        public double Value
        {
            get { return this.value; }
        }
  
   public string CounterPath
        {
            get { return this.counterPath; }
        }
  public string ComputerName
        {
            get { return this.computerName; }
        }
  
   public string Date
        {
            get { return this.date; }
        }
     
    }
"@
 
#------------------------------------------------------This script will loop all the counters and calcualte the average value
function Cal([string]$filename)
{
    $PathCount=0;
    $CounterArray=import-counter $filename
    $PathCount=$CounterArray[0].CounterSamples.Count
    for($i=0;$i -lt $PathCount;$i++)
    {
        $total=0
        foreach ($singleCounterArray in $CounterArray)
        {
        $total=$total+$singleCounterArray.CounterSamples[$i].CookedValue
        }
        $averageValue= $total/$CounterArray.count
        $countPath=$CounterArray[0].CounterSamples[$i].Path;
        $countPath=$countPath.Substring(2,$countPath.Length-2);#elminiate the first \\
        $computerName=$countPath.Substring(0,$countPath.IndexOf("\"));#get the computername 
        $countPath=$countPath.Substring($countPath.IndexOf("\"),$countPath.Length-$countPath.IndexOf("\"));#remove the computername 
        $date=[string]$CounterArray[0].Timestamp.ToString("yyyyMMdd");
        $counter=New-Object PerformanceCounter($computerName,$countPath,$averageValue,$date); 

        $c=$a.add($counter) # $.add operation will output the number of PerformanceCounter,  add $c to elimiate the behavior
    }
}

if ($folderPath -eq "")#$folderPath can't be empty
 {
    funhelp
    exit
 }
 
$a=New-Object System.Collections.ArrayList
Add-Type -TypeDefinition $source
$blgList=Get-Item $folderPath -include *.blg
$processedNumber=0
foreach($blg in $blgList)
{
 $processedNumber=$processedNumber+1
 Cal([string]$blg.FullName)
 Write-Host   $processedNumber "files of " $blgList.count "have been processed"
}
Write-Host "Process done, Please wait..." -ForegroundColor Green
$filename="result"+[system.datetime]::now.ToString("yyyyMMddhhmmss")+".csv"
$a |Export-Csv $filename
Write-Host "Please check" $filename "for detail" -ForegroundColor Green

 

 

 

下面是csv文件的效果图

1

2

3