Database maintenance, Data export – HP P6000 Performance Advisor Software User Manual

Page 31

Advertising
background image

In addition, the statistical data includes the recent value, which is the most recent data sample
collected. If you choose to no longer monitor a performance or stop data collection, the recent
value continues to show the last data sample collected for that object in HP P6000 Performance
Advisor. When you select aggregated controller, the throughput and data transfers are sum of
both the controllers value and the latency is the weighted average with throughput value of both
the controllers.

Database maintenance

In HP P6000 Performance Advisor, you can perform various database maintenance activities to
free up disk space when required, such as export, purge, and backup and restore data.

Data export

The export activity enables you to copy historical data pertaining to a monitored storage system
into a CSV file. You can specify the duration for which the data should be exported, based on
which data for the current set of monitored performance objects is exported. The export activity
depends on the number of performance objects and the export duration that you select. More the
number of objects and longer the export duration, more time will be needed for the export activity
to complete.

You can initiate the export activity only for a storage system and not for performance objects. Also,
only one export activity can be in progress at a given point in time. Though you can execute
multiple export activities for storage systems, the export tasks are executed one after the other.
Those yet to be processed are in the 'Pending' state and the ones that are executed successfully
are moved to the 'Completed' state. If an export activity fails, the next in the queue is considered.
The duration taken for an export activity to complete depends on the current set of monitored
performance objects and the corresponding data for the specified duration. The exported data
contains both performance and state data for the corresponding monitored performance objects.
If you want the latest state data for a performance object to be exported, click Update Object Status
to manually update the state data or wait for HP P6000 Performance Advisor to automatically
update state of all performance objects based on the state data collection frequency configured
while adding a storage system or editing the configured settings for the storage system.

The format of the exported data in evaperf all output is similar to the output generated by the
following HP P6000 Performance Data Collector command:

evaperf all -sz <node-wwn> -csv ts2 –fo <filename> -cont <polling

interval configured for perf data collection>

The exported data can be formatted using the TLViz Formatter and then viewed using the TLViz
tool. For more information, see the HP Command View EVAPerf TLViz formatter section in the HP
P6000 Command View User Guide
.

The exported data will not contain any port statistics data, as the port statistics is not collected by
HP P6000 Performance Advisor. Additionally, while formatting the CSV using the TLViz Formatter,
you may see the following message at the end of formatting of the data: Input data for
following performance objects is missing: Loops. Output files for these

objects may not have valid data.

CAUTION:

When the export activity for a storage system is in progress, if you remove the storage

system itself from monitoring, the export activity fails. However, if you remove one of its
corresponding performance objects from monitoring, the export activity completes. Data pertaining
to that performance object up to the time it was removed from monitoring is exported. However,
if the performance object was removed from monitoring before the export started, the data for that
object is not exported.

Database maintenance

31

Advertising
This manual is related to the following products: