P9000Watch and P9000Sketch Reference guide for HP StorageWorks P9000 Performance Advisor v5.3 (T1789-96325, August 2011)

7 Viewing performance metrics in
P9000Sketch
This section describes loading the .csv files, setting the Java heap size value, and viewing performance
metrics in P9000Sketch.
Loading the Comma separated file
The performance metrics obtained on monitoring the selected XP or the P9000 disk arrays host
groups, ports, LDEVs, RAID, CPU, and DKC groups including the array level metrics for a specified
duration are stored in seven .csv files, one file for each component.
The .csv files generated using P9000Watch in the Interactive mode can be opened in P9000Sketch
to obtain a graphical representation of the data.
You must load the .csv file in P9000Sketch, which transforms the metrics into various data points
on the graph. You can also select multiple metrics and view the values plotted on the graph. Using
these graphical representations, you can analyze the performance trend, identify bottlenecks or
problems, and take the necessary corrective actions.
On the File menu, select Load to open the .csv file in P9000Sketch. If P9000Sketch is not installed
on the same system as P9000Watch, you can still copy the .csv file generated by P9000Watch,
and load it on the system (host) where P9000Sketch is installed.
If the format of the selected .csv file does not match the input file format that P9000Sketch requires,
an error message displays stating that the selected files format is not supported. The following is a
sample format of a .csv file:
$$$ START COLUMN HEADERS $$$
Sample Time
Metric1
Metric2
.
.
.
$$$ END COLUMN HEADERS $$$
Time in format ’MM-dd-yy hh:mm:ss’, value for Metric1, value for metric2,.....
Time in format ’MM-dd-yy hh:mm:ss’, value for metric1, value for metric2,…
Click File menu, and select Close to close the .csv file in P9000Sketch.
Click File menu, and select Exit to stop and close P9000Sketch.
NOTE:
The above sample is in the TLVIz format and seven .csv files are generated, one file for each
component.
P9000Watch and P9000Sketch Reference Guide 61