HP StorageWorks P9000 Performance Advisor Software v5.4 Troubleshooting and FAQs Guide (T1789-96336, April 2012)

Does purging or archiving of data also lead to defragmentation of the allocated
disk space?
It depends on the P9000 Performance Advisor version that is installed on your management station:
• In P9000 Performance Advisor versions prior to v3.5, purging of data does not explicitly defragment
the allocated disk space. If you want to reduce the database size after purging, you must use the
DefragmentDB.bat file and complete the following steps to reduce the database size:
1. Stop all the P9000 Performance Advisor services (Start -> Programs -> HP Storageworks ->
Stop services).
2. In the command prompt on your management station, go to the folder %PADB_HOME%\tools
and execute DefragmentDB.bat.
3. When the command is executing, the ssdebug.log messages appear in a pop-up window,
till the process of database size reduction is complete.
4. Verify the database size in the folder, %PADB_HOME%.
5. Start the P9000 Performance Advisor services (Start -> Programs -> HP Storageworks -> Start
services).
• In P9000 Performance Advisor versions v3.5 through v3.5.2, purging or archiving of data does
not automatically defragment the allocated disk space.
• In P9000 Performance Advisor v4.0, auto purging of data automatically defragments the allocated
disk space, so that the free space is released back to the database.
• In P9000 Performance Advisor v4.5 onwards, auto purging or archiving of data automatically
defragments the allocated disk space, so that the free space is released back to the database.
When will auto purge set in?
Auto purge sets in when the following conditions are met:
• Data storage exceeds 70% of the database size and the Auto Grow check box is not selected on
the Database – Configure screen.
• The Auto Grow check box is selected. However, adequate free disk space is not available in the
P9000 Performance Advisor database or on the management station.
• The database has grown to 320GB, which is the maximum size limit.
What happens if P9000 Performance Advisor is collecting data for an XP or a
P9000 disk array, for which records are simultaneously being purged? Will
there be discrepancy noticed in the data that is displayed on the P9000 Perform-
ance Advisor screens?
It depends on the kind of purge that is initiated:
• If it is a manual purge and the data being collected falls in the date range older than the date that
you have selected for purging, you may see discrepancy in the data being displayed on the P9000
Performance Advisor screens.
• If it is a manual purge for an XP or a P9000 disk array, all the data collected till the current col-
lection time is purged.
• If it is an auto purge, the latest data is still displayed on the P9000 Performance Advisor screens.
Consider the following scenarios:
• Case1: The purge start date is provided as the immediate next day for the manual purge to begin.
You may see discrepancy in the data that is displayed on the P9000 Performance Advisor screens,
HP StorageWorks P9000 Performance Advisor Software Frequently Asked Questions 61