How to collect historical data from HP StoreVirtual VSA??

[Tom Lyczko]

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

[Stor_Mort]

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.

[Tom Lyczko]

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]

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. 

[Tom Lyczko]

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]

<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]

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

[Tom Lyczko]

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 file

Thank you, Tom

[Stor_Mort]

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.

[Tom Lyczko]

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