Microsoft sql, Oracle, Microsoft sql oracle – HP 3PAR System Reporter Software User Manual
Page 33
installation or configuration, it is very simple to use but it has several limitations that make it only
suitable for small database sizes and limited concurrency.
SQLite supports only limited database concurrency because it relies on a single file lock for the
entire database. The sampling process needs exclusive access to the database when inserting new
samples. If the database is very large or if there are a large number of concurrent web requests,
the sampler or the Web server can time out. Furthermore, database compaction (see
) cannot be done in parallel with sample insertion so there could be a large
gap in samples during database compaction.
Sampling of multiple HP 3PAR StoreServ Storage systems is not supported with an SQLite database,
either the Microsoft SQL Server, MySQL or the Oracle database servers should be used instead.
For large databases (over about 1 GB) or a large number of concurrent Web users, either the
MySQL, Microsoft SQL, or the Oracle database servers should be used instead.
NOTE:
The optionally licensed Adaptive Optimization feature is not supported with the SQLite
database. Please consider another database if you plan on utilizing the storage optimization
capabilities provided by Adaptive Optimization.
Microsoft SQL
System Reporter supports Microsoft SQL database server. It is not included and must be purchased
separately. The Microsoft SQL server is not supported on Linux and does not support data generated
by System Reporter when installed on a Linux platform.
Oracle
System Reporter supports an Oracle database server. It is not included with it and must be purchase
separately. Compared with MySQL, Oracle is slightly slower and more resource intensive for
sample insertion and deletion. However, Oracle is also a good choice for large and active System
Reporter installation.
The Oracle database will have to be modified, with many insertions and deletions. Ideally, multiple
(small) file UNDO space and multiple (small) file tablespace is required for the data, resulting in
a size of approximately 100-200 MB, depending on the size of the HP 3PAR OS.
NOTE:
System Reporter does not currently support Oracle RAC implementations.
NOTE:
System Reporter requires the 32-bit Oracle client and does not support the 64-bit version.
NOTE:
If you choose Oracle as the database, you cannot install System Reporter on a 64-bit
Linux system since it requires a 32-bit Oracle client which is not supported on 64-bit Linux. This
limitation does not apply to the 64-bit Windows version since the 32-bit Windows version of Oracle
Client works on 64-bit Windows platforms.
provides a comparison of features for the various database choices.
Table 6 Database Comparison
Oracle
MySQL
Microsoft SQL
SQLite
Comment
No
No
No
Yes
Included with System
Reporter?
Yes
Yes
Yes
No
Sample more than one
HP 3PAR StoreServ
Storage?
Yes
Yes
Yes
No
Supports Adaptive
Optimization?
Yes
Yes
Yes
No
Can have remote
database server?
Installing the Database Server
33