Need to capture end user performance issues in a table that can be easily analyzed in a portlet

Idea ID 2705507

Need to capture end user performance issues in a table that can be easily analyzed in a portlet

We need the capability to capture performance issues experienced by the end users in a PPM table. This should get triggered based on a threshold value that can be set in server.conf. Currently you can see similar info in Threshold logs and by enabling parameters in logging.conf such as the one shown below. We would like to see this info written to a table in PPM for any transactions exceeding 12 seconds so that it will be easy to analyze and addressed.

com.kintana.core.logging.SYSTEM_THRESHOLD = DEBUG

com.kintana.core.logging.PRODUCT_FUNCTION_LOGGING_LEVEL = com.mercury.itg.SQL

Log Output:-

com.mercury.itg.SQL:13:19:37: Page /itg/project/ViewProjectOverviewPortlet.do 7203 ms SQL 1188 ms 216/45 uniques

com.mercury.itg.SQL:13:20:14: Page /itg/workplan/ViewWorkPlan.do?workPlanId=30000 3031 ms SQL 978 ms 135/47 uniques

com.mercury.itg.SQL:13:20:36: Page /itg/workplan/LoadTask.do?taskId=58004&workPlanId=30000 6015 ms SQL 396 ms 53/46 uniques

Tags (1)
6 Comments
Micro Focus Expert
Micro Focus Expert
Status changed to: Waiting for Votes
 
Micro Focus Contributor
Micro Focus Contributor

If we could calibrate the transaction duration parameter.

Micro Focus Expert
Micro Focus Expert

@PariP  You can already configure Web Requests (for full user request duration) & Portlet load duration parameter, refer to PPM help for Action Monitor & Portlet Monitor: https://admhelp.microfocus.com/ppm/en/9.50-9.54/Help/Content/SA/InstallAdmin/112750_InstallAdmin_Improve.htm

To monitor pure DB Transaction duration, this is something better done directly at the DB level, and Oracle provides plenty of tools for transactions monitoring.

Note that you can also use the PPM Debug Console to monitor individual SQL statements performance & statistics while loading a PPM page.

Micro Focus Frequent Contributor
Micro Focus Frequent Contributor

The above suggestion requires using JMX console. Ho do you use it on a linux instance? If a customer has 25 servers how do you monitor a specific user experience. Also, how do you track a user experience if they complain after a day? If it is captured in a single table i can access it thru a portlet.

Micro Focus Expert
Micro Focus Expert

JMX Console is one way to get real-time information from a specific PPM node (and you can leverage it by using any JMX console on Linux, including the JMX console included in PPM - same stuff on Windows by the way), but the standard way is to get info from the performance log files just like outputted in the first message of this thread.

Also, according to the PPM help documentation that I shared, looks like you can already save portlet perf information exceeding threshold in PPM DB Table PPM_PERFORMANCE_LOG by setting parameter PORTLET_MONITOR_PERSIST_STATE to true.

Micro Focus Expert
Micro Focus Expert
Status changed to: Already Offered

You can already save some performance Monitors (Portlet, UI Requests) to PPM Table PPM_PERFORMANCE_LOG by setting the following server parameters to true:

- PORTLET_MONITOR_PERSIST_STATE

- UI_MONITOR_PERSISTE_STATE

See these parameters in PPM Admin Console:

clipboard_image_0.png

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.