We are trying to troubleshoot some long-running queries in MAS 9. We have set the mxe.db.logSQLTimeLimit system property to 10 milliseconds, and the SQL logging to INFO.
There are no log messages in the log file indicating any queries taking more than 10 milliseconds (I did some queries in Work Order Tracking that I know took longer than 10 milliseconds). I did a similar test in a Maximo 7.6.1.3 environment, and the log files captured multiple queries that ran over 10 milliseconds.
Has anyone experienced this issue in MAS 9?
#MaximoApplicationSuite------------------------------
Theo Pozzy
OneGas
------------------------------