I am looking for a way to get a list of the top 5 highest average read/write IOPS and Latency per VM view in VRNI. I am not finding a way to do this so far. I can see the VMs peak IOPS but not average. I just am looking for a way to pin point VMs running hot in these areas over a long period of time, because some peaks are to be expected.
Here's an example search query to get the average write/read IOPs of VMs and sort them from high to low:
avg(Write IOPS) of VMware VM group by Name order by avg(Write IOPS)
It's similar for latency:
avg(Write Latency) of VMware VM group by Name order by avg(Write Latency)
Hope that helps,