HPE StoreVirtual Storage / LeftHand
cancel
Showing results for 
Search instead for 
Did you mean: 

How to collect historical data from HP StoreVirtual VSA??

Tom Lyczko
Super Advisor

How to collect historical data from HP StoreVirtual VSA??

We are trying to see if I/O issues exist in our HP VSA StoreVirtual.

How do we collect and review historical data??

Performance monitor only shows current activity.

Thank you, Tom

11 REPLIES
Stor_Mort
HPE Pro

Re: How to collect historical data from HP StoreVirtual VSA??

Hi Tom,

You can record performance metrics into a .csv file for later analysis with Excel, for example. Click on the triangle icon in the CMC Performance Monitor by the Export: option at the top of the frame. See the attached file for a picture of the collection options you can set up.

For long duration captures like multiple days, you may want to sample interval less frequently, such as 30 seconds.

 

I am an HPE employee - HPE StoreVirtual Support
Tom Lyczko
Super Advisor

Re: How to collect historical data from HP StoreVirtual VSA??

Hello, thank you for the information!!

Hopefully the data will help us understand our next steps.

Can anyone suggest how Excel might best be used to review the data?? -- as graphs or anything similar, PLEASE??

Thank you, Tom

Stor_Mort
HPE Pro

Re: How to collect historical data from HP StoreVirtual VSA??

I usually delete column A which is the date/time in UTC. Column B is the local date/time including seconds.

In Excel 2013, Select a column of data. On the Insert ruler, select a recommended chart, such as a 2-D line chart. There are many options from there which an Excel tutorial can explain better than I. 

I am an HPE employee - HPE StoreVirtual Support
Tom Lyczko
Super Advisor

Re: How to collect historical data from HP StoreVirtual VSA??

OIC!! That's a good start...select the day/time column plus another column, go from there...

I will try this and see how it goes, thank you for pointing me in the right direction.

Thank you, Tom

Tom Lyczko
Super Advisor

Re: How to collect historical data from HP StoreVirtual VSA??

<pre>
400 secs|GMT	 America/New_York
 02/08/2017 08:51:15	11873344.22
 02/08/2017 08:51:20	11873344.22
 02/08/2017 08:51:24	11790731.98
 02/08/2017 08:51:30	11790731.98
 02/08/2017 08:51:34	11855870.98
 02/08/2017 08:51:40	11855870.98
 02/08/2017 08:51:44	4253056.15
 02/08/2017 08:51:49	4253056.15
 02/08/2017 08:51:54	1140456.30
 02/08/2017 08:51:59	1140456.30
</pre>

I did like you suggested and removed the original Column A with UTC time in it.

Now the new Column A is the current timezone time, with header 400 secs | GMT

And the new Column B has header America/New York and I can not figure out what the numbers are!!

 WHAT is the numbers in the 2nd column??

Thank you, Tom

Stor_Mort
HPE Pro

Re: How to collect historical data from HP StoreVirtual VSA??

That doesn't look like a .csv file any more. Go back to the original capture file. After you make any changes, save it as a .csv file. Opening it in a text editor should look like this. The column headers identify the metric, in this case, Time (CST), Throughput and IOPS. The metrics in the file depend on what you selected in the CMC.

GA482|GA482|CST, ClusterTotalBytes|Throughput Total|B/s|48|GA482|CLUSTER, ClusterIoTotal|IOPS Total|IO/s|48|GA482|CLUSTER
01/31/2017 09:19:38,2.58E+07,1478.369219
01/31/2017 09:19:48,1.70E+07,1259.292476
01/31/2017 09:19:58,1.81E+07,1213.595136
01/31/2017 09:20:08,1.68E+07,1201.932656

I am an HPE employee - HPE StoreVirtual Support
Tom Lyczko
Super Advisor

Re: How to collect historical data from HP StoreVirtual VSA??

I know what the csv is and looks like.

What I pasted in is an *excerpt* from the csv file after converting it to Excel and getting rid of the exponential notation which I as a normal human can not read. :)

I've attached a screencap of the original csv file, I want to know what means the data in the America/New York column, please.

screencap of original csv filescreencap of original csv file

Thank you, Tom

Stor_Mort
HPE Pro

Re: How to collect historical data from HP StoreVirtual VSA??

The column headers are shifted for some reason. The first column is the GMT (UTC) date. Column B is the Americas/New York time (EST). Column C is your Cluster Total Throughput and so on.

I am an HPE employee - HPE StoreVirtual Support
Tom Lyczko
Super Advisor

Re: How to collect historical data from HP StoreVirtual VSA??

OIC!! (ouch!!) Got it, now I know what to do...I hope. Thank you for explaining!! :) :)

M. N.
Advisor

Re: How to collect historical data from HP StoreVirtual VSA??

 I need to schedule performance data collection on more LeftHand clusters. For example, I would like to collect performance data for 3 days between 10:00 AM and 12:00 AM and between 15:00 PM and 17:00 PM.

Can I schedule data collection so that I have data easy to be compared?

Does data collection impact on performance?

Regards

M.N.

Stor_Mort
HPE Pro

Re: How to collect historical data from HP StoreVirtual VSA??

Hi M. N., 

Sorry, the GUI does not have automation that allows you to schedule a performance collection run. You will need to start them manually at your preferred time.

I have not seen a case where performance collection caused any noticeable performance impact on iSCSI traffic. Depending on the number of metrics being monitored, your CMC workstation may become loaded down. If you monitor too many metrics, the CMC will not be able to log all of them and you will have gaps in the data. Reduce the number of metrics or lengthen the sample interval if that happens.

I am an HPE employee - HPE StoreVirtual Support