The following items are frequently asked questions regarding Precise Workload Analysis for SAP HANA.

How often does the Precise Workload Analysis for SAP HANA sample?

Every second.

How often does the sample data is sent to PMDB?

Every 30 seconds.

How often does the Web GUI update?

Every 15 seconds.

What privileges are required for the user created in HANA to install Workload Analysis for SAP HANA?

The user must have CATALOG READ, INIFILE ADMIN, and OPTIMIZER ADMIN privileges for monitoring SAP HANA.

Does a single installer support both 64-bit and 32-bit processors?

Yes.

We have a firewall between Precise FPs and the Database Servers for SAP (including HANA DB).  What port is used by the agent to connect to HANA DB?

The following ports are used by Workload Analysis for SAP HANA:

  • 20701 (PMDB)
  • 20705 (MQ)
  • 20700 (GUI)

Is it possible to change the GUI port for Workload Analysis for SAP HANA?

Yes, but there is no option to change it in the GUI. It can be changed manually from ports.ini and server.xml files in the Workload Analysis for SAP HANA installation directory.

To change the GUI port:

  1. Stop the services.
  2. Find and replace the required ports in the following files:
    • <FW_ROOT>\deploy\etc\ports.ini
    • <FW_ROOT>\etc\ports.ini
    • <FW_ROOT>\tomcat\conf\server.xml (Only for the GUI port)
  3. Start the services.

What open ports are required on the HANA server for Workload Analysis for SAP HANA to work?

The port that is used for communication between Workload Analysis for SAP HANA is 3NN15 (Single Container Server) and/or 3NN13 for (Multiple Container Server), where NN is the instance number, which is taken as an input during the installation. The default instance number is 00, hence the default port would be 30015 or 30013.

Is it possible to upgrade the Workload Analysis for SAP HANA framework from v0.0.1 to v0.0.2

There is no upgrade path. The existing product should be uninstalled and the new version installed. To access the GUI of the newly-installed version, your browser cookies and cache should be deleted as the structure of widgets has changed in the newer version.


IDERA Website | Products | Buy | Support | Community | About Us | Resources | Legal

  • No labels