We try to place some kind of sql monitoring for too long query (to execute).
Using -sqllimit:10, we log everything that we want.
The only problem is... this is logged in log files like a normal log (into sm.log)...
We more hope set "performance" or "audit" log (which should only have sql error or warning) in a different log file.
I remember in SM6, we having that kind of log (sc.alert.log) but with SM9.31 we seem to lost this feature.
I set "alertquerylimit:1000", this add some "Performance alert" into sm.log.
Did there is a way to go back to a "sm.alert.log" for "Performance alert" ?