Exporting storage system performance information
Storage Advisor Embedded provides two different methods of exporting performance data.
- Use the CSV export tool in individual volume performance monitor reports to export the performance information currently shown in the reports. You can use this information for quick analysis.
- Use Export Tool 2 to export the performance information accumulated by your storage system. You can also use this tool to save and accumulate data over extended periods of time for long-term analysis and future reference.
Both tools output information in CSV format. You can analyze the CSV by using any spreadsheet software.
By default, the storage system records performance information for the last 24 hours in the CFMs. The CFMs have 288 plots (storage area) and by default, performance information is recorded every 5 minutes. When performance information is recorded in the last plot, the storage system returns to the first plot to continue recording.
You can increase the amount of performance information stored in the CFMs by changing the collection interval. You can set the collection interval from 5 - 60 minutes (in 5 minute intervals). For example, if you set the collection interval to 60 minutes, the recording period becomes 60 x 288 = 17280 minutes, which means you can store 12 days of information.
For VSP E series with DKCMAIN microcode version 93-06-21 or later, you can specify the CUs for which performance information is collected (target CUs). If the number of target CUs is less than 33, you can change the collection interval in the range from 1 to 15 minutes (1 minute intervals), and performance information is recorded in 1440 plots. For example, if you set the number of target CUs to less than 33 and the collection interval to 1 minute, the recording period becomes 1 x 1440 = 1440 minutes, which means you can store 1 day of information. For details, see add cu.
When you change the microcode version, the performance information accumulated in the CFMs is reset. Then, performance information for all CUs is recorded every 5 minutes, which is the default. This applies to an upgrade or downgrade between a version earlier than 93-06-21 and a version of 93-06-21 or later.
Exporting performance data for a volume to a CSV file
Export performance data for volumes to save and analyze it.
You can view real-time performance data for a single volume and export it. If the OS of the management client is Windows Server and the browser is Internet Explorer, disable Internet Explorer Enhanced Security Configuration, or use Google Chrome.
If you observe anything unusual in the operating status of a volume, you can export up to five minutes of data for evidence.
Procedure
In the dashboard, click Volumes, and then click a volume name to open the volume detail page.
Data displays in the Performance Monitor after a brief period of time.Click CSV Export in any of the three graphs.
Exporting performance data using the Export Tool 2
Export Tool 2 allows you to export the performance information accumulated by your storage system. By exporting and storing the information, you can analyze health status, troubleshoot, and predict future storage performance. You can also use Export Tool 2 to save and accumulate data over extended periods of time for long-term analysis and future reference. The performance information exported by Export Tool 2 is output in CSV format. You can analyze the CSV by using spreadsheet software. For details, see Using Export Tool 2.
Some typical reasons to export past performance data are:
- A performance issue is found in some part of the environment, such as servers or the network.
- There is a need to analyze peak time to use when considering workload splitting.
- To analyze long-term performance trends, and aid in deciding when to expand the environment.
Checking and changing the collection interval of the performance information
From Export Tool 2, you can access the storage system and specify the collection interval of the performance data. The default interval is 5 minutes, and the collected data is updated daily. You can set the collection interval between 5 and 60 minutes in multiples of 5. If the collection interval is 60 minutes, the data can be retained for 12 days.
Before you begin
- Install Export Tool 2. For details, see Installing Export Tool 2.
- Register a user account to which only the Storage Administrator (Performance Management) role is assigned.
Procedure
Open the Windows command prompt or the Linux terminal on the computer on which Export Tool 2 is installed.
Go to the Export Tool 2 installation directory.
Use the show interval command to check the collection interval set on the storage system.
Specify the IP address of the management port of the storage system in the -ip parameter.
Specify the user account and password in the -login parameter.
In Windows :
runWin.bat show interval –ip 192.168.0.16 -login export_user tropxe00
In Linux :
runUnix.sh show interval –ip 192.168.0.16 -login export_user tropxe00
To change the collection interval, use the set interval command.
Specify the collection interval in the -interval parameter. The collection interval can be set between 5 and 60 minutes in multiples of 5.
In Windows :
runWin.bat set interval –ip 192.168.0.16 -login export_user tropxe00 –interval 10
In Linux :
runUnix.sh set interval –ip 192.168.0.16 -login export_user tropxe00 –interval 10
Close the Windows command prompt or the Linux terminal.
Exporting the performance information
From Export Tool 2, access the storage system and output the performance data, specifying an output directory of the CSV file, a time range, and a performance metrics group.
Before you begin
The user must have Storage Administrator (Performance Monitor) role assigned.
Procedure
On the computer where Export Tool 2 is installed, open the Windows command prompt or the Linux terminal.
Navigate to the Export Tool 2 installation directory.
Verify the collection time of the performance data accumulated in the storage system.
Use the show range command to specify the IP address of the management port of the storage system in the -ip parameter.
Specify the user account and password in the -login parameter.
In Windows:
runWin.bat show range –ip 192.168.0.16 -login export_user tropxe00
In Linux:
runUnix.sh show range –ip 192.168.0.16 -login export_user tropxe00
Output Example:
2017/03/31 12:20:30 2017/03/31 12:30:30 : 2017/04/01 12:10:30
Output the performance data to a file by using the export data command.
Specify the output directory path in the -outpath parameter. When omitted, the performance data is output under the installed directory (monitor2\out).
Specify a time range for the performance data that you want to output in the -range parameter. When omitted, the performance data accumulated in the storage system for the entire period is output.
Specify a performance metrics group name that you want to output in the -group parameter. When omitted, all groups are output.
Specify the option in the -option parameter.
- To compress the performance information in zip format, enter compress. For no compression, enter nocompress. When omitted, the option is set to compress.
- If a file or folder with the same name exists in the output directory of the file, enter ask to prompt whether to delete the file or folder. To delete the file or folder, enter clear. When omitted, the option is set to clear.
-
To list the resource ID in a row for exported data, enter resourceid_on_row. This means that each record contains performance information for each collection time and resource. To list the resource ID by column, enter resourceid_on_column. This means that each record contains performance information for multiple resources collected at the same time.
You can specify this option for VSP E series with a DKCMAIN microcode version of 93-06-21 or later.
For additional information, see the export data command.
In Windows:
runWin.bat export data –ip 192.168.0.16 -login export_user tropxe00 –outpath c:\\exportlog -range 201704010020:201704011210 –group MP ParityGroup LDEV LU Port –option noncompress clear resourceid_on_row
In Linux:
runUnix.sh export data –ip 192.168.0.16 -login export_user tropxe00 –outpath c:\\exportlog -range 201704010020:201704011210 –group MP ParityGroup LDEV LU Port –option noncompress clear resourceid_on_row
Output Example:
+----+----+----+----+----+----+----+----+----+----+ ===================================> 70.0%
The progress state and the progress rate are displayed.
When the performance data output is complete, 100.0% is displayed for the progress rate.
Close the Windows command prompt or the Linux terminal.