Page History
This section topic includes the following sub-topics:
...
Precise registry parameters should be set in the <Precise_root>\products\i3fp\registry\products\infrastructure\sts\settings.xml file:
Table A- 1 Registry parameters in the settings.xml file
...
In the <Precise_root>\products\i3fp\registry\products\pw\maintain\db-sizes.xml file:
Table A- 2 Registry parameters in the db-sizes.xml file
...
In the <Precise_root>\products\i3fp\registry\products\insight\focalpoint.xml file:
Table A- 3 Registry parameters in the focalpoint.xml file
...
In large environments you have to update the memory configuration for the Precise framework JVMs in the relevant XML files. The following code example indicates where you have to insert the parameter in those files (replace <number> with a number). The <jvm-options> section appears in all files:
The memory configuration for the Precise framework JVMs (XMX configuration) should be as follows:
Table A- 4 Memory configuration
| Component | Size | Location |
|---|---|---|
Precise FocalPoint | 1024 MB | <Precise_root>\products\i3fp\bin\psin_i3fp_init.xml |
J2EE FocalPoint | 512 MB | <Precise_root>\products\j2ee\bin\psje_focal_init.xml |
PMDB FocalPoint | 768 MB | <Precise_root>\products\pw\bin\pspw_focal_init.xml |
Insight FocalPoint | 2048 MB | <Precise_root>\products\insight\bin\psis_focal_init.xml |
Web FocalPoint | 768 MB | <Precise_root>\products\www\bin\psww_focal_init.xml |
Web Data Loader | 768 MB | <Precise_root>\products\www\bin\psww_dataloader_init.xml |
GUI FocalPoint | 1024 MB | <Precise_root>\products\gui\website\bin\psin_gui_init.xml |
...
The memory configuration for each production server with either J2EE, Web, or .NET should be as follows
Table A- 5 Memory configuration
| Component | Size | Location |
|---|---|---|
Listener | 356 MB | <Precise_root>\infra\bin\psin_listner_java_init.xml |
...
The following tables describe the Oracle-based PMDB configuration parameters and sizing recommendations that need to be inserted in the init.ora file for Oracle 11g:
Table A- 6 Oracle 11g-based PMDB configuration parameters
| Parameter | Value |
|---|---|
MEMORY_TARGET | 45 GB |
MEMORY_MAX_TARGET | 45 GB |
LOG_BUFFER | 5 MB |
| SESSIONS | 1500 |
PROCESSES | 1000 |
UNDO_RETENTION | 7200 |
DB_WRITER_PROCESSES | 4 |
Table A- 7 Oracle 11g-based PMDB sizing recommendation
...
The following tables describe the Oracle-based PMDB configuration parameters and sizing recommendations that need to be inserted in the init.ora file for Oracle 10g:
Table A- 8 Oracle 10g-based PMDB configuration parameters
| Parameter | Value |
|---|---|
SGA_TARGET | 45 GB |
SGA_MAX_TARGET | 45 GB |
LOG_BUFFER | 5 MB |
SESSIONS | 1500 |
| PROCESSES | 1000 |
UNDO_RETENTION | 7200 |
DB_WRITER_PROCESSES | 4 |
Table A- 9 Oracle 10g-based PMDB sizing recommendation
...
The following table describes the SQL Server-based instance configuration parameters as displayed in Figure 1:
Table A- 10 SQL Server-based instance configuration parameters
| Parameter | Value |
|---|---|
SQL Server memory | 44000 MB |
Minimum memory per query | 307200 KB |
Figure 1 Server Properties with SQL Server-based instance configuration parameters
The following table describes the SQL Server-based PMDB (database) configuration parameters for the files as displayed in Figure 2:
Table A- 11 SQL Server-based PMDB (database) configuration parameters for the files
...
| Info |
|---|
The autogrowth parameter should be 100 MB. |
Figure 2 Database Properties with SQL Server-based PMDB (database) configuration parameters for the files
The following table describes the SQL Server-based PMDB (database) configuration parameters for the options as displayed in Figure 3:
Table A- 12 SQL Server-based PMDB (database) configuration parameters for the options
| Parameter | Value |
|---|---|
Auto Update Statistics | True |
Auto Update Statistics Asynchronously | True |
Auto Create Statistics | On |
Recovery Model | Simple |
Figure 3 Database Properties with SQL Server-based PMDB (database) configuration parameters for the options
The following table describes the SQL Server-based tempdb configuration parameters as displayed in Figure 4:
Table A- 13 SQL Server-based tempdb configuration parameters
| Parameter | Value |
|---|---|
tempdb Auto Update Statistics | False |
tempdb Auto Update Statistics Asynchronously | False |
tempdb Auto Create Statistics | False |
Figure 4 Database Properties with SQL Server-based tempdb configuration parameters
| Anchor | ||||
|---|---|---|---|---|
|
...
The following table shows the environments that we tested in our laboratory:
Table A- 14 Tested environments
| Criteria | Oracle-based PMDB | SQL Server-based PMDB |
|---|---|---|
J2EE instances | 300 | 180 |
Web instances | 150 | 90 |
Total number of instances | 450 | 270 |
| Server platform | Linux 64-bit | Windows 2008 64-bit |
| Processors | Dual quad core CPU X5570 (8 core) | Dual 6 core CPU X5670 (12 core) |
| Physical memory | 68 GB (Oracle SGA - 45 GB) | 60 GB (SQL Server memory - 44 GB) |
Storage for data files | EMC Symmetrix VMAX | Local 15 K SAS disks |
Data files size | 1.5 TB | 1 TB |
...