HP 3PAR System Reporter Software - Manual (Page 36)

2.8 Using the Database Schema to Build Custom Reports
3PAR System Reporter User’s Guide System Reporter 2.8
2.9 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 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.
See Chapter 10, Database Schema for details on how to utilize the database schema.
2.10 Analyzing and Optimizing Storage Utilization
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.
See Chapter 9, Using Adaptive Optimization for complete details.