How do you create a report/line graph that displays latency for specific volumes in OnCommand 5.0

tgf · ‎2011-10-26

I have a customer that is interested in distributing a report to certain user groups when performance of a specific application, MS-SQL, is poor. The report would be run on a specific volume and review latency over a time range and display a line graph. Can this be done in OnCommand Performance Advisor? Customer reports or export of OnCommand to excel or other application.

Thanks

Tom Franco

804-399-4555

reide · ‎2011-11-08

Tom,

Performance Advisor (PA) can do this right out of the box. Because you're using MS-SQL, I'm going to assume you're actually using LUNs within FlexVols (and possibly within a qtree). In PA, navigate to the controller/volume/qtree/LUN that you're wanting to report on and highlight it. On the right, you should be viewing the "LUN Summary View". One of the charts should be "Average Latency". In that chart, use the "Range" menu to specify how far back in time you want to see latency data. The default is 1 hour.

From here you can:

Right-click on the graph and do a "Save as...". This will save the graph to a PNG image which you can use in your reports, powerpoints, etc... It will add headers to the graph to specify the time range of the data and a legend.
Go to File -> Export. This allows you to export the performance data to a CSV file. The counters you're allowed to export depends on the view you had open when you selected File -> Export.

Reid

reide · ‎2011-11-09

You can also extract the raw performance data from the CLI of the OnCommand server. This makes it very easy to script/schedule this output and then import it elsewhere (i.e. Excel, SAS) to create your own graphs and reports.

# dfm perf data retrieve help # prints instructions on how to use this command

dfm perf data retrieve -o 603 -V "Lun Summary View" -b "2011-11-08 08:00:00" -e "2011-11-08 08:10:00"

Timestamp       603:read_ops
--------------------------------------
2011-11-08 08:01:41     0.200
2011-11-08 08:02:41     0.200
2011-11-08 08:03:41     0.200
2011-11-08 08:04:41     0.200
2011-11-08 08:05:41     0.200
2011-11-08 08:06:41     0.200
2011-11-08 08:07:41     0.200
2011-11-08 08:08:41     0.200
2011-11-08 08:09:41     0.200

Timestamp       603:write_ops
--------------------------------------
2011-11-08 08:01:41     2.133
2011-11-08 08:02:41     0.817
2011-11-08 08:03:41     1.583
2011-11-08 08:04:41     1.517
2011-11-08 08:05:41     1.283
2011-11-08 08:06:41     1.467
2011-11-08 08:07:41     1.483
2011-11-08 08:08:41     1.350
2011-11-08 08:09:41     1.350

Timestamp       603:other_ops
--------------------------------------
2011-11-08 08:01:41     0.300
2011-11-08 08:02:41     0.300
2011-11-08 08:03:41     0.300
2011-11-08 08:04:41     0.300
2011-11-08 08:05:41     0.300
2011-11-08 08:06:41     0.300
2011-11-08 08:07:41     0.300
2011-11-08 08:08:41     0.300
2011-11-08 08:09:41     0.300