Hello,
I would like to come up with a script that will monitor all disks on all powered on machines for read and write latency as well as number of writes. I am basically trying to create a tool that will help me better choose which machines might benefit from virtual flash read-cache resources. I have set my statistic level to 2 for all counters except 5min which I set to 4. I am basically wanting to run a script every X mins or hours which will collect these stats per disk and store them in a CSV until i get a a DB setup. I found some code that was written by LucD (i think) that I think should work for this report, but its not working in my environment. The counters are coming back as null. What am I doing wrong? I am able to go into vcenter and look at the performance tabs and see this data for at least the past day, so i know at least some data exists. I have copied my code below:
# Main Variables
$sVCentre = "virtualcenter"
$strVMWildCard = "*"
$strCSVName = "Stats-AvgVMDiskWriteStatsWorkingday"
$strCSVLocation = "c:\temp\"
$metrics = "virtualDisk.totalWriteLatency.average","virtualDisk.totalReadLatency.average",
"virtualDisk.numberReadAveraged.average","virtualDisk.numberWriteAveraged.average",
"virtualDisk.read.average","virtualDisk.write.average"
#define the start and finish times for a working day.
$today9am = (Get-Date -Hour 9 -Minute 0 -Second 0)
$today5pm = (Get-Date -Hour 17 -Minute 0 -Second 0)
$intStartDay = -1
$intEndDay = -1
#Begin Script
#Connect to VC
Connect-VIServer $sVCentre -ea silentlycontinue
$arrVMs = Get-Cluster "Prod 1" | Get-VM | where-object {$_.Name -like $strVMWildCard} | Sort Name
$stats = Get-Stat -Entity $arrVMs -Stat $metrics -Start $today9am.AddDays($intStartDay) -Finish $today5pm.AddDays($intEndDay)
#group the data and collate the stats into averages for the day.
$groups = $stats | Group-Object -Property {$_.Entity, $_.MetricId, $_.Instance}
$report = $groups | % {
New-Object PSObject -Property @{
Description = $_.Group[0].Description
Entity = $_.Group[0].Entity
EntityId = $_.Group[0].EntityId
Instance = $_.Group[0].Instance
MetricId = $_.Group[0].MetricId
Timestamp = $_.Group[0].Timestamp.Date.AddHours($_.Group[0].Timestamp.Hour)
Unit = $_.Group[0].Unit
Value = [math]::Round(($_.Group | Measure-Object -Property Value -Average).Average, 2)
}
}
#Exporting the report to a CSV file.
$strCSVSuffix = (get-date).toString('yyyyMMddhhmm')
$strCSVFile = $strCSVLocation + $strCSVName + "_" + $strCSVSuffix + ".csv"
$report | Export-Csv $strCSVfile -NoTypeInformation -UseCulture
