HP 3PAR StoreServ 7000 Storage - Manual (Page 22)

Using the Database Schema to Build Custom Reports
The databases used by System Reporter are standard relational databases capable of supporting
SQL queries. The default (built-in) database is SQLite (see
http://www.sqlite.org ) but MySQL®,
Microsoft SQL Server, and Oracle database servers can optionally be used instead. The database
schema is documented so you can write your own reports by directly querying the System Reporter
database.
For details about using the database schema, see “Database Schema” (page 192) .
Analyzing and Optimizing Storage Utilization
For HP 3PAR OS 3.1.1 or OS 2.3.1, an optionally licensed component called Adaptive
Optimization is included with System Reporter. Adaptive Optimization analyzes sub-volume, region
level disk access rates for a given array over a scheduled period of time and then performs a data
migration of regions between tiers according to a cost versus performance preference. Disk utilization
is optimized by having frequently accessed data moved to the higher performance tier (e.g., RAID
1 using Solid State Disks or SSDs) while infrequently accessed data is moved to the lower cost tier
(e.g., RAID 6 on Nearline disks). By using Adaptive Optimization, you can achieve a much higher
degree of control over disk usage by reserving your faster and more expensive storage resources
for the data that is frequently accessed and relegating your slower and less expensive drives to
storing data that is only occasionally accessed.
NOTE: This applies to HP 3PAR OS 3.1.1 or OS 2.3.1 only. For HP 3PAR OS 3.1.2 and later,
Adaptive Optimization is performed by the HP 3PAR OS; a separate license is not necessary.
22 Overview and Features