HP 3PAR System Reporter Software User Manual
Page 26
Figure 2 HP 3PAR StoreServ Storage 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 30)
).
•
Sampler components. The sampler components are responsible for sampling performance
and space information from the HP 3PAR StoreServ Storage 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 StoreServ Storage 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 115)
).
–
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 StoreServ Storage array for which Adaptive Optimization is
configured (see
“Selecting an HP 3PAR StoreServ Storage for Adaptive Optimization”
). 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.
26
Installation, Configuration, Update, and Removal