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

together in a single web page. You can do this by creating an html file that includes multiple iframe
elements, each of which includes a standard web report query.
See “Web Queries” (page 126) for details on how to instigate web queries.
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 for details on how to utilize the database schema.
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.
24 Overview and Features