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

Using the System Reporter Sizing Spreadsheet
Before installing System Reporter, you need to determine the system resources that are required to
adequately run System Reporter and the selected data base server. The optimal computing power
(CPU cores), memory and storage space needed to accommodate the data that is sampled by
System Reporter and used to generate reports depends on the number of systems and the amount
of storage that is being monitored for your particular installation. An Excel spreadsheet named
SR_Sizing.xls (
Figure 1 (page 25) ) is included with System Reporter for the purpose of determining
the optimal system resources that are recommended for running System Reporter and the database
server at your site. This spreadsheet is included on the installation CD.
NOTE: The System Reporter Sizing Spreadsheet is protected except for the cells in red, but you
can turn off the protection to see the formulas that are used to derive a given value.
Entities in the spreadsheet are color coded. Only the values into controls or cells colored red need
to be set. Cells or ranges in yellow are output values that you can use to size or configure the
server that you will use to run System Reporter. Values in blue are empirically determined parameters
used to drive the sizing model.
Figure 1 System Reporter Sizing Spreadsheet
1. Click the appropriate type of database that you are using for System Reporter at your site.
You will notice that SQlite only supports one HP 3PAR StoreServ Storage for use with System
Reporter. Please consider another database if you plan on using System Reporter to monitor
more than a single HP 3PAR StoreServ Storage.
Using the System Reporter Sizing Spreadsheet 25