HP 3PAR System Reporter Software User Manual
Page 29
Figure 2 HP 3PAR Storage System and User Interface Components
•
Database. The HP 3PAR System Reporter database is capable of supporting SQL queries.
Four types of databases are supported: Microsoft SQL Server, SQLite, MySQL and Oracle
(see
“Installing the Database Server” (page 32)
).
•
Sampler components. The sampler components are responsible for sampling performance
and space information from the HP 3PAR Storage System arrays, saving the data in the
database, and removing old samples from the database. The sampler components include
the following:
◦
The sampling service (sampleloop) runs as a service on Windows or as a daemon on
Linux. It creates and coordinates other sampler components.
◦
A separate inservsample process is created for each HP 3PAR Storage System being
sampled. This process in turn creates a separate CLI process that runs the sampler script
which logs into the array and collects the required data. The inservsample process then
inserts the data into the database. Along with the tables that contain the space and
performance data, the database also includes inventory tables that allow quicker creation
of report menus. The inservsample process also update the inventory tables.
◦
For MySQL, Microsoft SQL Server (Windows only), and Oracle databases, the sampleloop
service/daemon creates a separate process to maintain the database (since SQLite
supports limited concurrency, these functions are performed by the sampleloop process).
These include:
–
The trimdb process removes samples that are older than the sample retention period
specified in the sampling policies (see
“Configuring Sampling Policies” (page 112)
).
–
The dedupinv process removes duplicate entries from the inventory tables.
–
The compactdb process periodically compacts and optimizes the database when
necessary.
•
Adaptive Optimization components. The sampleloop process also creates a regionmover
process for each HP 3PAR Storage System array for which Adaptive Optimization is configured
(see
“Selecting an HP 3PAR Storage System for Adaptive Optimization” (page 179)
). Each
regionmover process analyzes region level performance data for each Adaptive Optimization
configuration and generates region moves between tiers. The regionmover process creates a
separate CLI process that logs into the array and executes the mvrg program that executes
the data movement commands on the array.
System Reporter Components
29