LucD notes

Hello Luc,

i am using the below script for disk IOPs calculation, but it is not working if i remove “-Realtime” switch, lets say i am calculating it for last week, please have a look where its going wrong.

$metrics = “disk.numberwrite.summation”,”disk.numberread.summation”
$start = (Get-Date).AddDays(-7)

$report = @()

$vms = Get-VM THASCCMSRV
$stats = Get-Stat -Realtime -Stat $metrics -Entity $vms -Start $start
$interval = $stats[0].IntervalSecs

$lunTab = @{}
foreach($ds in (Get-Datastore -VM $vms | where {$_.Type -eq “VMFS”})){
$ds.ExtensionData.Info.Vmfs.Extent | %{
$lunTab[$_.DiskName] = $ds.Name
}
}

$report = $stats | Group-Object -Property {$_.Entity.Name},Instance | %{
New-Object PSObject -Property @{
VM = $_.Values[0]
Disk = $_.Values[1]
IOPSMax = ($_.Group | `
Group-Object -Property Timestamp | `
%{$_.Group[0].Value + $_.Group[1].Value} | `
Measure-Object -Maximum).Maximum / $interval
IOPSAvg = ($_.Group |
Group-Object -Property Timestamp | `
%{$_.Group[0].Value + $_.Group[1].Value} | `
Measure-Object -Average).Average / $interval
Datastore = $lunTab[$_.Values[1]]
}
}

$report | Export-Csv “C:\IOPSMax-report.csv” -NoTypeInformation -UseCulture -ErrorAction SilentlyContinue

I’m having a hard time with the script. I’m using the vSphere PowerCLI, I connect to a vSphere host and execute the script. It repeats this line over and over:

[vSphere PowerCLI] C:\Scripts\vmware\PowerCLI\VC02> C:\Scripts\vmware\PowerCLI\V
C02\get_iops.ps1
New-Object : A parameter cannot be found that matches parameter name ‘Property’
.
At C:\Scripts\vmware\PowerCLI\VC02\get_iops.ps1:17 char:34
+ New-Object PSObject -Property <<<< @{
New-Object : A parameter cannot be found that matches parameter name 'Property'
.

I copied the code using the widget and it looks right to my eye. What could be missing?

Hi LucD,

How can I get disk size details in same script

Hi LucD,

Thank you so much for the script. It’s exactly what I need to get the necessary information for our DR Site requirements. I’m currently battling to get the same information, but for a specific date/time range. I added the following, but I receive a “Cannot index into a null array” error after I run the script and the csv file is empty. I also removed the “-Realtime” as that would ignore the start/finish options.

$start = “06 Aug 2012 08:00″
$finish = “06 Aug 2012 17:00″
$stats = Get-Stat -Stat $metrics -Entity $vms -Start $start -Finish $finish

Any help would be greatly appreciated.

Many thanks,
Kenny

I would like to use The NFS datastore version to get the report for the period of last 30 days. Could you please help me to append the script.

@ LucD

How can I get the disk size information in this script.

Hi Luc,

In the NFS version of this script is it possible to have another field with the disk capacity? like this:

IOPSMaxDisk VM Datastore TotalSize

Hi Luc,

Thx a lot for these scripts. I do have a question to ask you: I’m not sure how to interpret the values that are returned by the NFS script. For instance for one of my VM’s I get 11,5 IOPS Max for one of its vdisks whilst in esxtop CMD/s for this vdisk is constantly between 250 and 450?

I’m using the NFS version of the script exactly like you posted on this page.

Thx!
B.

Hi Lucd, Excellent script and very helpful.
Need help i wanted to run as schedule task every hour and append the info with time stamp in to an file. How do i achieve that if you could help???

Many Thanks

Hey Luc,
Getting an error I can’t explain:

Cannot index into a null array.
At C:\Users\roderick\Desktop\iops.ps1:7 char:20

Cheers
Roderick

Great script, saved me a bunch of time today….. now time to go investigate some ‘top talkers’.

Cheers,
Doug

@LucD

Hi LucD,

Hope you had a nice weekend. I increased the level to 3 and was still getting an error before I realized I needed to add the following switch

$stats = Get-Stat -Stat $metrics -Entity $vms -Start $start -Finish -Disk

Now I am getting results.

Thanks again

@LucD

Hi LucD,

They were set to 2. So I set it to 3 in the 5min interval duration saving for 1 day. So the original script worked because it had the realtime switch.

Thanks again
Thanks again

@LucD

Ah ok thanks again

@LucD
Hi LucD,

Thanks again for assisting me with this. I heard at your talk at vmworld you were quick to answer questions on your site . So I tried finish before and was getting a null result. The actual error message is as follows. The metric counter “disk.numberread.summation” doesn’t exist for entity” My Start and end times are within 3 hours so

$start = (Get-Date).AddHours(-14) #Friday, October 28, 2011 12:48:50 AM
$finish = (Get-Date).AddHours(-12) #Friday, October 28, 2011 2:48:50 AM

Any help is appreciated and again these are great scripts thanks

Hi LucD,

Hopefully you are still monitoring this thread. I am using both of your disk stats script regarding IO average and maximums. We have an issue that happens at 1:00am on and off for about an hour. Could we adapt the script to just monitor that time period instead of an entire day? Is this possible with get-stat? I am about average with powershell and I am still wrapping my head around your script.

Thanks again

Hi Luc

Would possible to amend this script to get the IOPS per VMDK file per VM.

Thanks
Darren

This is great stuff but I need it to work with VMs in a NFS Datastore. Can this be done?

@LucD
That’s exactly what I was looking for. Thanks.

Is there a way to get the average read and write ratios? Thanks.

@LucD

Sorry I was unclear. Using your max IOPS script, what if I wanted to add together two NoteProperty values such as MaxIOPS and IOPSAve to create a third noteproperty value called IOPSNumber for each VM (lines 18-24). Of course adding those two specific values makes no sense, but that’s the general concept I can’t quite master in PS. Is that clearer?

@LucD

LucD,

How would you perform a math function on existing group-object NoteProperty values and create a new NoteProperty based on that calculated value?

Thanks for the great script! I used it as a basis for a more VDI oriented report that shows total read/write IOs, read/write ratios, etc.

http://derek858.blogspot.com/2011/06/powercli-script-to-dump-vm-io-stats.html

For some reason I’m getting this error message… Any suggestion?

vSphere PowerCLI] C:\> foreach($ds in (Get-Datastore -VM $vms | where {$_.Type -eq “VMFS”})){
$ds.ExtensionData.Info.Vmfs.Extent | %{
$lunTab[$_.DiskName] = $ds.Name
}
}
$report = $stats | Group-Object -Property {$_.Entity.Name},Instance | %{
New-Object PSObject -Property @{
VM = $_.Values[0]
Disk = $_.Values[1]
IOPSMax = ($_.Group | `
Group-Object -Property Timestamp | `
%{$_.Group[0].Value + $_.Group[1].Value} | `
Measure-Object -Maximum).Maximum / $interval
Datastore = $lunTab[$_.Values[1]]
}
}
$report | Export-Csv “C:\IOPSMax-report.csv” -NoTypeInformation -UseCulture
Missing closing ‘)’ in expression.
At line:11 char:1
+ <<<< Group-Object -Property Timestamp | `
+ CategoryInfo : ParserError: (CloseParenToken:TokenId) [], ParentContainsErrorRecordException
+ FullyQualifiedErrorId : MissingEndParenthesisInExpression

Awsome script!

Is it possible to also calculate the average iops?

This would be great addition for my daily storage reporting!

As i already said on Twitter, thank you!
The only thing i don´t get is the convertion from canonical names to datastore names. i “studied” the other post you mentioned but as i already said, i don´t get it. can you point me out in which section of the lun report script you are doing the conversion?

thanks!

Gernot

Great Stuff! Is there a way to export-csv the three columns?