HP 3PAR StoreServ 7000 Storage - Manual (Page 26)

2. Modify the Sampling Parameters in red to reflect the approximate values for your installation.
The values for Table Row Sizes in blue are approximate table row sizes (bytes) based on
observations derived by HP during testing System Reporter instances and includes some extra
space to accommodate typical inventory tables, indexes, etc.
3. Observe the requirements that are shown in the yellow cells to determine the suggested
allocation of system resources for your System Reporter server or database server.
NOTE: The database server should have roughly the same amount of memory and CPU
cores as the System Reporter server.
System Reporter Components
System Reporter includes the following components ( Figure 2 (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
26 Installation, Configuration, Update, and Removal