HP System Reporter E-Media Kit manual 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.

2.8

Using the Database Schema to Build Custom Reports