There is a background service running every sunday that calculates statistics, and also you can do it via kconfig ui. How you can make sure it calculates statistics, im doint in toad count a table and check wheter the count is same as number of rows in stat/size; and controlling last analyzed date.
If a page or portlet exceeds the threshold value an entry will be logged into the PPM_PERFORMANCE_LOG table.
PPM administrators can validate user complaints about performance and analyze data about specific users or pages in PPM
Server.conf settings needed:
com.kintana.core.server.ENABLE_UI_MONITOR=true com.kintana.core.server.UI_MONITOR_THRESHOLD=1 (this value in milliseconds) com.kintana.core.server.UI_MONITOR_PERSIST_STATE=true
com.kintana.core.server.ENABLE_PORTLET_MONITOR=true com.kintana.core.server.PORTLET_MONITOR_THRESHOLD=1 (this value in milliseconds) com.kintana.core.server.PORTLET_MONITOR_PERSIST_STATE=true
--NOTE: If you want to store any query/page taking more than 5 seconds, that will be 5000 miliseconds....
First, add the parameters to server.conf, run kUpdateHtml.sh and restart.
If you are in a 9.1 release prior to 9.1 sp4, you need to also perform the next steps
you can enable the monitoring through the JMX console and has to be done for each node individually.
For each node in your cluster
1) go to http://<server>:<port>/admin-jmx (username=admin password=mercitg)
2) scroll to the bottom under ppm.monitor
3) Under "name=ActionMonitorFilter,type=Action", set EnableMonitor = TRUE, and click apply changes
4) Go back to the previous page.
5) Under "name=ActionMonitorTrigger,type=Action", set PersistStat=TRUE and Threshold=1, and click apply change (this will log the all pages that take more than 1ms to the database. For our initial analysis we want everything to be logged)
6) Go back to the previous page
7) Under "name=PortletPerformanceMonitor,type=Portlet", set PersistStat=TRUE and Threshold=1, and click apply change
8) In order to start the Portlet monitor you will have to click the "invoke" button under "Void start()". If the monitor is running the State=3 and StateString=Started. If there are any problems you can destroy or stop then restart the monitor from this page.
You should start to see entries in the PPM_PERFORMANCE_LOG table in the PPM database schema if these are set properly.