#45 sqllog appears to be truncated on IQ because of asemon

[Anonymous]

Hi,
apparently when asemon is executed against an IQ server (16), the sqllog gets truncate every 5 mins.
The last message on the log is:
i+6769,<,1,EXEC_ANY_IMM, execute "sp_iqsysmon" 'stop_monitor' execute "sp_iqsysmon" 'start_monitor'

[Anonymous]

Looks like the problem is in
"IQSQL.xml"

-- next two steps allow reset of sqltrace file
exec sa_server_option 'requestlogging', 'NONE'
exec sa_server_option 'requestlogging', 'SQL+REPLACE'
exec sa_server_option 'RequestLogMaxSize','?MAXTRCSQLSIZE?'

Why do you reset the sqllog?

[Jean-Paul Martin]

This is the wanted behaviour.
Asemon truncates the log to avoid log growing and to get only the new statements during the next collect
If you don't want this, you can remove the IQSQL.xml collector in your config file.