Export db csv files – HP XP Performance Advisor Software User Manual
Page 150
MP blade. You can export data from the .csv files to a data visualization program, such as
Microsoft Excel. For more information about the generated .csv files, see
.
The .csv files are created when you export data for a specified duration or schedule it as a daily,
weekly, or monthly activity. The .csv files are stored in the following location on the management
station: \HPSS\pa\tomcat\webapps\pa\reports.
You can perform the following tasks under the Export DB tab that appears when you click PA and
DB Settings+Database Manager in the left pane.
•
Export performance and utilization data into .csv files under the Export DB/Schedule Export
DB tab. You can save and view the .csv files when required, or schedule the export activities
on a periodic basis.
•
View the .csv files by selecting the corresponding records in the Exported DB Files section,
under the View Exported/Scheduled Exported DB Files tab.
•
Delete the records for the .csv files or the schedules in the Scheduled Export DB tasks section,
under the View Exported/Scheduled Exported DB Files tab.
The Export Database report functionality provided through the HP XP7 Performance Advisor GUI
is same as that available from CLUI.
Related Topics
•
“Creating Export DB CSV files” (page 153)
•
“Viewing Export DB CSV files” (page 158)
Export DB CSV files
This section describes the following .csv files you can view when you save or schedule an Export
DB report:
ldev_exportDB-array_serial_number_
This file includes the following details:
•
The
XP/XP7 disk array serial number for which the report is generated.
•
The LDEVs present during the specified duration.
•
The RAID groups to which the LDEVs belong.
•
The performance data collection interval time stamps.
•
The data for the following metrics:
RIO Read Cache Hits, RIO Reads, RIO Write Cache Hits, and RIO Writes.
◦
◦
SIO Read Cache Hits, SIO Reads, SIO Write Cache Hits, and SIO Writes.
◦
Total IO, Inhibit Mode IO Count, and Bypass Mode IO Count.
◦
Backend Transfer Sequential Reads, Backend Transfer Non-Sequential Reads, and Backend
Transfer Writes.
◦
Random MB Reads and Random MB Writes.
◦
Sequential MB Reads and Sequential MB Writes.
◦
Average Read Response Time (msec) data for every 200 msec and Maximum Read
Response Time (msec) data for the last 30 seconds.
◦
Average Write Response Time (msec) data for every 200 msec and Maximum Write
Response Time (msec) data for the last 30 seconds.
150
Managing the HP XP7 Performance Advisor database