Generating the performance information file

Storage Advisor Embedded User Guide

Version
93-07-2x
88-08-12
Audience
anonymous
Part Number
MK-97HM85022-25

The performance information file is generated in CSV or ZIP format based on the setting of the “-option” parameter in the export data command.

The performance information file includes the following:
  • Date: Date on which the performance data was recorded (YYYY/MM/DD)
  • Time: Time at which the performance data was recorded (HH:MM)
  • ID: Resource ID (for example, CL1-A when "port" was specified)
  • <performance metric>: Description of the calculated performance data (for example, Total_IOPS, Write_Pending_Rate)
When you generate the performance information file, a separate file called "export_metadata.csv" is also output to the same directory. This metadata file contains the following information that identifies the data in the performance information file:
  • Serial number: 6-digit serial number of the storage system
  • Product name: Product name of the storage system (for example, VSP G700)
  • From: Start date and time (YYYY/MM/DD HH:MM) of the data (specified by the -range parameter of the export data command)
  • To: End date and time (YYYY/MM/DD HH:MM) of the data (specified by the -range parameter of the export data command)
  • Sampling: sampling interval (minutes) of the data

The following example shows the meta information file content:

“Serial Number”,”Product Name”,”From”,”To”,”Sampling”
"410025",”VSP G700”,”2017/04/13 15:00”,”2017/04/14 15:00”,”5”
The following example shows content from the CSV file:
"Date","Time","ID","Total_IOPS"
"2017/07/10","18:00","CL1-A/1122334455667788<HOST_A>","10"
"2017/07/10","18:00","CL1-A/1122334455667788<HOST_A>","10"
"2017/07/10","18:00","CL1-A/1122334455667788<HOST_A>","10"

SAS Port#

The resource “SAS Port#” that is output by the MP group can be converted to the package location (PK LOC) format. The following table describes the correspondence between PK LOC and SAS Port#, so that you can calculate “PK LOC”.

PK LOC VSP G900/VSP F900/VSP E990

VSP E1090

VSP G700/VSP F700 VSP E590/VSP E790 VSP G350/VSP F350, VSP G370/VSP F370
SAS Port# (port0,port1 in SAS) SAS Port# (port0,port1 in SAS) SAS Port# (port0,port1 in SAS) SAS Port# (port0,port1 in SAS)
1A
1B 0x04,0x05
1C 0x00,0x01
1D
1E 0x04,0x05
1F 0x06,0x07
1G 0x00,0x01 0x00,0x01 0x00,None
1H 0x02,0x03 0x02,0x03 0x02,None
2A
2B 0x0c,0x0d
2C 0x08,0x09
2D
2E 0x0C,0x0D
2F 0x0E,0x0F
2G 0x08,0x09 0x08,0x09 0x08,None
2H 0x0A,0x0B 0x0A,0x0B 0x0a,None