PowerCLI Script to dump VDI VM IO Stats

During a VDI pilot you really need to gather some real-world stats on how your client VMs are performing. People generally underestimate the workload VDI can put on a SAN. Thankfully if you are using vSphere 4.x, you can easily pull the stats with a short PowerShell script. I took a great script LucD has overe here and changed it up a bit to be more VDI specific. I’ll be the first to admit PowerShell is an area I need to learn more in, so the script could probably be more efficient, but hey, this works for me!

Unlike the LucD version, this requires a couple of command line arguments so you can more rapidly change the VM names and time period you are reporting against. The first argument is the VM name and the second is whole number which represents the number of minutes the stats need to be displayed for. The report is displayed both on the screen and dumped to a CSV file with a unique date stamp, so you don’t accidentally overwrite your results.

Unfortunately VMware sets the minimum realtime stats sample size at 20 seconds, so the IOPSmax value is over a 20 second interval. Within that 20 seconds there could well be higher spikes, so don’t take that value as the absolute max. Make sure you take into account the 20 second window when setting the sample time, so you don’t lose some data.

Update: Script has been modified a bit so that you can use wildcards for the hostname and it will properly calculate all the stats for each VM.

——-

$vms = $args[0]
$time = $args[1]
$metrics = “disk.numberwrite.summation”,”disk.numberread.summation”
$start = (Get-Date).AddMinutes(-$time)
$report = @()
$stats = Get-Stat -Realtime -Stat $metrics -Entity $vms -Start $start
$interval = $stats[0].IntervalSecs
$date = get-date -format “dd-hh-mm-ss”
$report = $stats | Group-Object -Property {$_.Entity.Name},Instance | %{

$AvgIOPS = [math]::round((($_.Group | `
Group-Object -Property Timestamp | `
%{$_.Group[0].Value + $_.Group[1].Value} | `
Measure-Object -Average).Average / $interval),2)

$MaxIOPS = ($_.Group | `
Group-Object -Property Timestamp | `
%{$_.Group[0].Value + $_.Group[1].Value} | `
Measure-Object -maximum).maximum /$interval

$WriteIOs = ($_.Group | Group-Object -Property Timestamp | `
%{$_.Group[0].Value} | Measure-Object -sum).sum

$ReadIOs = ($_.Group | Group-Object -Property Timestamp | `
%{$_.Group[1].Value} | Measure-Object -sum).sum

$TotalIOs = ($_.Group | `
Group-Object -Property Timestamp | `
%{$_.Group[0].Value + $_.Group[1].Value} | `
Measure-Object -sum).sum

$ReadRatio = [math]::round(($readios / $totalios),2)

$WriteRatio = [math]::round(($writeios / $totalios),2)

New-Object PSObject -Property @{
VM = $_.values[0]
AvgIOPS = $Avgiops
MaxIOPS = $MaxIOPS
WriteIOs = $writeios
ReadIOs = $readios
TotalIOs = $totalios
ReadRatio = $readratio
WriteRatio = $writeratio
}
}

$report | Export-Csv “D:\IOPSMax-report-$date.csv” -NoTypeInformation -UseCulture