Reply to Message

View discussion in a popup

Replying to:
TheVMinator
Expert
Expert

mark.j wrote:

You can do what you want via the formulas / SMs / and dashboards within vCOps. You don't want to avg the values of the 2 VMs together, then get the 9th percentile. You want to get the 95th percentile of the VM individually or get the 95th percentile of the SUM of the CPU demand for both VMs. Getting a 95th percentile of an AVG is going to smooth your data too far and negate the benefits of the 95th percentile analysis.

So.. use the data distro to display the 95th perc of cpu demand for a CPU or SUM of CPU for VMs, observe it, and there you go. There is no CSV value because 95th percentile is a single number.. not a time series. If you wanted the raw data, just go to a normal metric graph and export the raw data points and manipulate the data yourself.

If you want to do an export of the metric data on a large scale, see using the repository adapter as discussed in the custom ui admin guide. However, this is likely going to be overkill for the few resources/datapoints your looking for.

OK thanks.  So I'm happy getting the raw datapoints from the metric graph widget.  I can do that now already and get a list of all the data points in a single csv for a single VM.  Excel can average them no problem.  The problem is how to get those datapoints for multiple VMs on the same csv.  I'm still not completely clear as to how I can solve this problem. Even if I create a supermetric and attach the supermetric to a resource tag containing multiple VMs, when I go back into the metric graph widget, I still can only make the supermetric give me data points on a single VM at a time.  I cannot seem to make it give me data points which represent the SUM of CPU demand for more than one VM so that I can download it in one CSV.  Are you saying I should be able to make the SUM of CPU demand more than one VM appear on the metric graph so I can download that SUM into a csv?

Reply
0 Kudos