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

•
Manage only one storage system in one instance of System Reporter when a storage system
has more than 32000 VLUNs.
•
Update the max_allowed_packet parameter value to 128M in MySQL configuration file.
For more information, see “Setting the max_allowed_packet parameter” (page 41) .
•
Perform the following steps if the custom report generation fails or takes long time in a highly
scaled environment:
◦ Reduce the period for the report generation.
◦ Reduce the number of selected objects for report generation.
◦ Use schedule reports.
System Reporter Components
System Reporter includes the following components ( Figure 2 (page 28) ):
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 32) ).
•
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
28 Installation, Configuration, Update, and Removal