Page History
...
For further detailed requirements, see Precise minimum requirements for installation.
Precise for MS-SQL requirements
In order to monitor MS-SQL with Precise, you first must set up the framework server.
Precise 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.
...
| Info |
|---|
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. |
Supported OS versions for the Precise framework server
The Precise framework server includes the following operating system requirements:
- Microsoft Windows Server
- 2008
- 2012
- 2016
- 2019
Precise PMDB database
The Precise framework server also needs an MS-SQL database instance to support the Precise Performance Management Data Base (PMDB) database.
Supported database versions for the PMDB database
The Precise framework server includes the following MS-SQL database requirements:
...
| Info |
|---|
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. |
Communication requirements
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.
Additional framework requirements
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. |
Recommend / what-if functionality
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.
Requirements for the user interface
The user interface includes the following software requirements.
...
| Info |
|---|
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 MS-SQL Agent (Collector)
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.
Recommend / what-if functionality
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.
Precise for Oracle requirements
In order to monitor Oracle with Precise, you first must set up the framework server.
Precise 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.
...
| Info |
|---|
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. |
Supported OS versions for the Precise framework server
The Precise framework server includes the following operating system requirements.
...
| Operating System | Version |
|---|---|
| Microsoft Windows Server |
|
| Sun Solaris (x86 & SPARC) |
|
| IBM AIX (64-bit) |
|
| Linux (x86 64-bit) |
|
Precise PMDB database
The Precise framework server also needs an Oracle database instance to support the Precise Performance Management Data Base (PMDB) database.
Supported database versions for the PMDB database
The Precise framework server includes the following Oracle database requirements:
...
The Precise Framework server also needs the Oracle client installed so that it can communicate with the PMDB database instance.
Communication requirements
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.
Additional framework requirements
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. |
Requirements for the user interface
The user interface includes the following software requirements.
...
| Info |
|---|
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 Oracle Agent (Collector)
Precise monitors Oracle as a single instance. In addition, it monitors Multi Tenant Architecture (Containers) and Oracle RAC instances.
...
During the installation, a Super-user (root) privilege is required on Linux operating systems.
Precise for Db2 requirements
In order to monitor Db2 with Precise, you first must set up the framework server.
Precise 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.
...
| Info |
|---|
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. |
Supported OS versions for the Precise framework server
The Precise framework server includes the following operating system requirements.
...
| Operating System | Version |
|---|---|
| Microsoft Windows Server |
|
| Sun Solaris (x86 & SPARC) |
|
| IBM AIX (64-bit) |
|
| Linux (x86 64-bit) |
|
Precise PMDB database
| Info |
|---|
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.
Supported database versions for the PMDB database
The Precise framework server includes the following Oracle database requirements:
...
| Info |
|---|
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. |
Communication requirements
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.
Additional framework requirements
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. |
Requirements for the user interface
The user interface includes the following software requirements.
...
| Info |
|---|
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 Db2 Agent (Collector)
Precise monitors Db2 as a single instance or as a partitioned environment.
...
- You must create a dedicated Precise OS user on each monitored DB2 server or partition.
- It must be connected to the DB2 SYSADM group (as reported by the DB2 GET DBM CFG command).
- For monitoring purposes, the Precise user must have the DBADM and SYSMON privileges or SYSADM privileges.
Precise for Sybase requirements
In order to monitor Sybase with Precise, you first must set up the framework server.
Precise 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.
...
| Info |
|---|
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. |
Supported OS versions for the Precise framework server
The Precise framework server includes the following operating system requirements:
- Microsoft Windows Server
- 2008
- 2012
- 2016
- 2019
Precise PMDB database
| Info |
|---|
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.
Supported database versions for the PMDB database
The Precise framework server includes the following MS-SQL database requirements:
...
| Info |
|---|
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. |
Communication requirements
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.
Additional framework requirements
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. |
Requirements for the user interface
The user interface includes the following software requirements.
...
| Info |
|---|
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 Sybase Agent (Collector)
Precise monitors Sybase using remote collectors or local collectors on the monitored instance.
...
- ASE 12.5.4.0
- ASE 15.0.0 - 15.0.3
- ASE 15.5
- ASE 15.7
- ASE 16.0 SP03
- Replication Server
- 15.1
- 15.2
- 15.6
- 15.7
Installation tips
- The user on the server from where you are running the Sybase collector must have admin rights on both the local host and to the server where the Sybase instance is running. The password is also required for the installation.
- Make sure you have access to an existing Sybase user name with the system administrator privileges.
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 - Make sure that the user used to monitor the Sybase instance is a member of the mon_role and sa_role server roles.
- Check that the mon and master tables are activated.
- Run the sp_sysmon system stored procedure with the noclear option. For example, sp_sysmon 00:01:00, noclear
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 Info 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.