Subscribe

OPM SQL Tables

Trying to move away form DFM and looking at alternative solutions to produce my performance capacity reports. OPM is good but I need to be able to export reports containing Mean, Max, Min and 95th Percentile stats. Graphite is not going well, so looking at this option (below), but need some support in better understanding what I can see. I have linked to OPM's SQL database, but I need some sort of reference table (schema) to get a better understnading of the Tables I'm linked to. Also, it would be helpful to know what each of the "objid" enteries are relating to:

 

netapp pic.jpg

 

Any help or other suggstions to help me make the most of OPM would be great, thank you.

Re: OPM SQL Tables

Hello:

 

I understand you are trying to create performance reports.

Could you please share with us what are the usage of the reports which cannot be done by the product? Is there any other alternative? For e.g. ability to export data to a file?

We dont expose the tables to end users. We would like to understand your use case.

 

Thanks.

-Avijit

Re: OPM SQL Tables

Hi, thank you for your interest.

 

I'm running the following commands (for example) in DFM, to pull out specific performance statistics:

 

dfm perf data retrieve -o netapp001-02:netapp001_02_data01 -C aggregate:total_transfers -b "2015-12-18 13:00:00" -e "2015-12-25 14:00:00" -m mean

dfm perf data retrieve -o netapp001-02:netapp001_02_data01 -C aggregate:total_transfers -b "2015-12-03 13:00:00" -e "2015-12-03 14:00:00" -m min

dfm perf data retrieve -o netapp001-02:netapp001_02_data01 -C aggregate:total_transfers -b "2015-12-03 13:00:00" -e "2015-12-03 14:00:00" -m max

dfm perf data retrieve -o netapp001-02:netapp001_02_data01 -C aggregate:total_transfers -b "2015-12-03 13:00:00" -e "2015-12-03 14:00:00" -m value_at_percentile -P 95

 

OPM doesn't seem to have this functionality. I get close with Graphite, but only in a pictorial fashion.

 

Re: OPM SQL Tables

I am also a need of creating customized performance report.  The sample_volume_"VSobjid"  looks like having all volume performance stats residing inside specific VS.  The time stamp looks like in 13 digit unix epoch (GMT) format with five minute interval. but when I am plotting graph , it is not matching with the graph what i saw in the OPM GUI. May be I missed something. Can some one help me in this regard.