Performance alert into another log file?


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" ?


Thank you,