Use the following links to access requirements for each specific database supported by Precise:
For further detailed requirements, see Precise minimum requirements for installation.
In order to monitor MS-SQL with Precise, you first must set up the framework server.
Install the Precise Framework Application on a physical server or virtual machine. It should conform to the specifications shown in the following table. Note that you may use smaller specifications for an evaluation environment, but if you want to use the Precise framework server for production, make sure that the server is sized large enough to support the expected number of monitored instances.
Table 1 Required hardware for the Precise framework server
Cores | Real Memory | File System | PMDB Storage | Comments | |
---|---|---|---|---|---|
Small systems | 2-4 | 4 GB-10 GB | 20 GB - 50 GB | 20 GB - 50 GB | |
Medium systems (21-100 instances) | 4-8 | 10 GB - 32 GB | 20 GB - 50 GB | 80 GB - 200 GB | |
Large systems (101-500 instances) | 8-16 | 32 GB - 80 GB | 20 GB - 50 GB | 400 GB - 2000 GB | See System configuration requirements for large environments |
On large systems, it is recommended that you use two servers: one for the framework and one for the PMDB. In addition, the PMDB should be on an external storage system. |
The Precise framework server includes the following operating system requirements:
The Precise framework server also needs an MS-SQL database instance to support the Precise Performance Management Data Base (PMDB) database.
The Precise framework server includes the following MS-SQL database requirements:
Precise creates a database in the MS-SQL instance for the Precise PMDB database, which is case sensitive.
It is recommended that you use MS-SQL Enterprise edition for the Precise PMDB. Precise does work with MS-SQL Standard edition, but you must switch off partitioning in the installation section. |
Precise ports are as follows:
If your environment is firewall protected, enable the TCP ports noted above. If this port range is already in use, see Advanced adding servers for information about how to change ports.
Table 2 Additional framework requirements
Product/Framework | Privilege |
---|---|
All product installation on each server | Any installation on Microsoft Windows servers requires local administrator privileges. |
PMDB | OS authentication or MS-SQL authentication. The user must have Sysadmin permissions. When the PMDB is installed using Windows authentication, you must provide a user that can connect to both the PMDB and the monitored instance. |
If you want to use the Recommend/What-If feature in Precise for MS-SQL, you must install the SQL Server Client tool on both the Precise for MS-SQL FocalPoint and Collector servers. Make sure that the versions match on all servers. For example, when using MS-SQL 2019, make sure to install the 2019 client on both the FocalPoint and collector servers.
The user interface includes the following software requirements.
Table 3 User interface software requirements
Item | Version |
---|---|
Browser |
|
Report Manager - Reports | Adobe Acrobat 6 or later |
Report Manager - Customized Reports | Microsoft Excel 2007 or later |
Microsoft Internet Explorer is not fully supported for the Precise AdminPoint. |
The user interface includes the following hardware requirements.
Table 4 User interface hardware requirements
Item | Version or Size |
---|---|
Operating system | Microsoft Windows
OR Microsoft Windows Server
|
Memory | 1 GB+ |
Display | 24-bit color palette and SVGA (1024-768) resolution or higher |
The Precise user interface uses pop-up windows. If you use pop-up blockers, you must prevent them from blocking Precise-related pop-up windows. |
You can use Precise to monitor MS-SQL using remote collectors or local collectors on the monitored instance. The user on the server from which you are running the SQL Server collector must have admin rights on both the local host and to the server where the SQL instance is running. The password is required for installation.
If you want to use the Recommend/What-If feature in Precise for MS-SQL, you must install the SQL Server Client tool on both the Precise for MS-SQL FocalPoint and Collector servers. Make sure that the versions match on all servers. For example, when using MS-SQL 2019, make sure to install the 2019 client on both the FocalPoint and collector servers.
In order to monitor Oracle with Precise, you first must set up the framework server.
Install the Precise Framework Application on a physical server or virtual machine. It should conform to the specifications shown in the following table. Note that you may use smaller specifications for an evaluation environment, but if you want to use the Precise framework server for production, make sure that the server is sized large enough to support the expected number of monitored instances.
Table 5 Required hardware for the Precise framework server
Cores | Real Memory | File System | PMDB Storage | Comments | |
---|---|---|---|---|---|
Small systems | 2-4 | 4 GB-10 GB | 20 GB - 50 GB | 20 GB - 50 GB | |
Medium systems (21-100 instances) | 4-8 | 10 GB - 32 GB | 20 GB - 50 GB | 80 GB - 200 GB | |
Large systems (101-500 instances) | 8-16 | 32 GB - 80 GB | 20 GB - 50 GB | 400 GB - 2000 GB | See System configuration requirements for large environments |
On large systems, it is recommended that you use two servers: one for the framework and one for the PMDB. In addition, the PMDB should be on an external storage system. |
The Precise framework server includes the following operating system requirements.
Table 6 Precise framework server operating system requirements
Operating System | Version |
---|---|
Microsoft Windows Server |
|
Sun Solaris (x86 & SPARC) |
|
IBM AIX (64-bit) |
|
Linux (x86 64-bit) |
|
The Precise framework server also needs an Oracle database instance to support the Precise Performance Management Data Base (PMDB) database.
The Precise framework server includes the following Oracle database requirements:
The charset must not be AL32UTF8. |
Precise creates a schema in the Oracle instance for the Precise PMDB database.
If the Oracle instance is a containerized instance, you must create the PMDB database in one of the Pluggable databases (PDBs) and not the container root.
It is recommended that you use Oracle Enterprise edition for the Precise PMDB. Precise does work with Oracle Standard edition, but you must switch off partitioning in the installation section. |
The Precise Framework server also needs the Oracle client installed so that it can communicate with the PMDB database instance.
Precise ports are as follows:
If your environment is firewall protected, enable the TCP ports noted above. If this port range is already in use, see Advanced adding servers for information about how to change ports.
Table 7 Additional framework requirements
Product/Framework | Privilege |
---|---|
All product installation on each server | Windows: Any installation on Microsoft Windows servers requires local administrator privileges. Unix: The Precise software owner account must have the following characteristics:
|
PMDB | Oracle user with DBA privilege. |
The user interface includes the following software requirements.
Table 8 User interface software requirements
Item | Version |
---|---|
Browser |
|
Report Manager - Reports | Adobe Acrobat 6 or later |
Report Manager - Customized Reports | Microsoft Excel 2007 or later |
Microsoft Internet Explorer is not fully supported for the Precise AdminPoint. |
The user interface includes the following hardware requirements.
Table 9 User interface hardware requirements
Item | Version or Size |
---|---|
Operating system | Microsoft Windows
OR Microsoft Windows Server
|
Memory | 1 GB+ |
Display | 24-bit color palette and SVGA (1024-768) resolution or higher |
The Precise user interface uses pop-up windows. If you use pop-up blockers, you must prevent them from blocking Precise-related pop-up windows. |
Precise monitors Oracle as a single instance. In addition, it monitors Multi Tenant Architecture (Containers) and Oracle RAC instances.
In order to monitor Oracle, Precise needs to install an agent on the monitored instance. The Precise for Oracle agent reads the Oracle SGA directly. To do so, the Precise user must be in the same group as the Oracle user to have access to the Oracle shared memory.
When installing a new Oracle agent on Windows with Oracle 12c and later, where:
UNIX
For UNIX servers:
Windows
For Windows servers:
During the Oracle agent installation, the installer creates a schema in the Oracle database. To do so, it is required to specify an Oracle user with sysdba privileges. This is used only during the installation. |
Precise products do not use or save the DBA user name or password for future use.
During the installation, a Super-user (root) privilege is required on Linux operating systems.
In order to monitor Db2 with Precise, you first must set up the framework server.
Install the Precise Framework Application on a physical server or virtual machine. It should conform to the specifications shown in the following table. Note that you may use smaller specifications for an evaluation environment, but if you want to use the Precise framework server for production, make sure that the server is sized large enough to support the expected number of monitored instances.
Table 10 Required hardware for the Precise framework server
Cores | Real Memory | File System | PMDB Storage | Comments | |
---|---|---|---|---|---|
Small systems | 2-4 | 4 GB-10 GB | 20 GB - 50 GB | 20 GB - 50 GB | |
Medium systems (21-100 instances) | 4-8 | 10 GB - 32 GB | 20 GB - 50 GB | 80 GB - 200 GB | |
Large systems (101-500 instances) | 8-16 | 32 GB - 80 GB | 20 GB - 50 GB | 400 GB - 2000 GB | See System configuration requirements for large environments |
On large systems, it is recommended that you use two servers: one for the framework and one for the PMDB. In addition, the PMDB should be on an external storage system. |
The Precise framework server includes the following operating system requirements.
Table 11 Precise framework server operating system requirements
Operating System | Version |
---|---|
Microsoft Windows Server |
|
Sun Solaris (x86 & SPARC) |
|
IBM AIX (64-bit) |
|
Linux (x86 64-bit) |
|
Db2 is supported only on an Oracle PMDB database instance. |
The Precise framework server also needs an Oracle database instance to support the Precise Performance Management Data Base (PMDB) database.
The Precise framework server includes the following Oracle database requirements:
The charset must not be AL32UTF8. |
Precise creates a schema in the Oracle instance for the Precise PMDB database.
If the Oracle instance is a containerized instance, you must create the PMDB database in one of the Pluggable databases (PDBs) and not the container root.
It is recommended that you use Oracle Enterprise edition for the Precise PMDB. Precise does work with Oracle Standard edition, but you must switch off partitioning in the installation section. |
Precise ports are as follows:
If your environment is firewall protected, enable the TCP ports noted above. If this port range is already in use, see Advanced adding servers for information about how to change ports.
Table 12 Additional framework requirements
Product/Framework | Privilege |
---|---|
All product installation on each server | Windows: Any installation on Microsoft Windows servers requires local administrator privileges. Unix: The Precise software owner account must have the following characteristics:
|
PMDB | Oracle user with DBA privilege. |
The user interface includes the following software requirements.
Table 13 User interface software requirements
Item | Version |
---|---|
Browser |
|
Report Manager - Reports | Adobe Acrobat 6 or later |
Report Manager - Customized Reports | Microsoft Excel 2007 or later |
Microsoft Internet Explorer is not fully supported for the Precise AdminPoint. |
The user interface includes the following hardware requirements.
Table 14 User interface hardware requirements
Item | Version or Size |
---|---|
Operating system | Microsoft Windows
OR Microsoft Windows Server
|
Memory | 1 GB+ |
Display | 24-bit color palette and SVGA (1024-768) resolution or higher |
The Precise user interface uses pop-up windows. If you use pop-up blockers, you must prevent them from blocking Precise-related pop-up windows. |
Precise monitors Db2 as a single instance or as a partitioned environment.
In order to monitor Db2, Precise needs to install an agent on the monitored instance. Make sure the following requirements are met:
In order to monitor Sybase with Precise, you first must set up the framework server.
Install the Precise Framework Application on a physical server or virtual machine. It should conform to the specifications shown in the following table. Note that you may use smaller specifications for an evaluation environment, but if you want to use the Precise framework server for production, make sure that the server is sized large enough to support the expected number of monitored instances.
Table 15 Required hardware for the Precise framework server
Cores | Real Memory | File System | PMDB Storage | Comments | |
---|---|---|---|---|---|
Small systems | 2-4 | 4 GB-10 GB | 20 GB - 50 GB | 20 GB - 50 GB | |
Medium systems (21-100 instances) | 4-8 | 10 GB - 32 GB | 20 GB - 50 GB | 80 GB - 200 GB | |
Large systems (101-500 instances) | 8-16 | 32 GB - 80 GB | 20 GB - 50 GB | 400 GB - 2000 GB | See System configuration requirements for large environments |
On large systems, it is recommended that you use two servers: one for the framework and one for the PMDB. In addition, the PMDB should be on an external storage system. |
The Precise framework server includes the following operating system requirements:
Sybase is supported only on an MS-SQL PMDB database instance. |
The Precise framework server also needs an MS-SQL database instance to support the Precise Performance Management Data Base (PMDB) database.
The Precise framework server includes the following MS-SQL database requirements:
Precise creates a database in the MS-SQL instance for the Precise PMDB database, which is case sensitive.
It is recommended that you use MS-SQL Enterprise edition for the Precise PMDB. Precise does work with MS-SQL Standard edition, but you must switch off partitioning in the installation section. |
Precise ports are as follows:
If your environment is firewall protected, enable the TCP ports noted above. If this port range is already in use, see Advanced adding servers for information about how to change ports.
Table 16 Additional framework requirements
Product/Framework | Privilege |
---|---|
All product installation on each server | Any installation on Microsoft Windows servers requires local administrator privileges. |
PMDB | OS authentication or MS-SQL authentication. The user must have Sysadmin permissions. When the PMDB is installed using Windows authentication, you must provide a user that can connect to both the PMDB and the monitored instance. |
The user interface includes the following software requirements.
Table 17 User interface software requirements
Item | Version |
---|---|
Browser |
|
Report Manager - Reports | Adobe Acrobat 6 or later |
Report Manager - Customized Reports | Microsoft Excel 2007 or later |
Microsoft Internet Explorer is not fully supported for the Precise AdminPoint. |
The user interface includes the following hardware requirements.
Table 18 User interface hardware requirements
Item | Version or Size |
---|---|
Operating system | Microsoft Windows
OR Microsoft Windows Server
|
Memory | 1 GB+ |
Display | 24-bit color palette and SVGA (1024-768) resolution or higher |
The Precise user interface uses pop-up windows. If you use pop-up blockers, you must prevent them from blocking Precise-related pop-up windows. |
Precise monitors Sybase using remote collectors or local collectors on the monitored instance.
Supported Sybase versions include:
Check that the Open Client and related ODBC version is one of the following:
Open Client | ODBC Version |
---|---|
12.5.1 ESD #2 | Sybase Adaptive Server Enterprise ODBC driver 4.20.00.67 |
12.5.1 ESD #15 | Adaptive Server Enterprise 12.05.01.529 |
15.x | Adaptive Server Enterprise 15.00.00.152 |
To enable monitoring of the Sybase app tier, adjust the Adaptive Server Enterprise (ASE) configuration parameters as specified in the following table:
Parameter | Value |
---|---|
max SQL text monitored | 16384 |
enable monitoring | 1 |
SQL batch capture | 1 |
wait event timing | 1 |
SQL text pipe active | 0 |
plain text pipe active | 0 |
statement pipe active | 0 |
errorlog pipe active | 0 |
deadlock pipe active | 0 |
process wait events | 0 |
object lockwait timing | 0 |
statement statistics active | 0 |
per object statistics active | 0 |
The value given for the event buffer per engine parameter in the table is a minimum value. You may also use a higher value, if required. |
| | | | | | | |